Color coding based on row selected

[TXT0VBI]

If we have a table and we select one particular row of the table then the values in the tables should be color coded based on the selected row values. For example if we select a project name then the values of all the projects in the table should be color coded based on the selected project values. In the below example if we select Trina Project then all the columns in the table $/ product1,$/product 2,$/Product3 should be color coded based on the Trina row values $/ product1,$/product 2,$/Product3

Project	Product	$/product1	$/Product2	$/Product 3
Jinko	P Type Bifacial	$0.3750	$   1,795	$       601
Jinko	N Type Bifacial	$0.3900	$   1,779	$       586
Trina	P Type Bifacial	$0.4350	$   1,859	$       614
LONGi		$0.3000	$   1,704	$       579

[AliceW]

Create a new column where you assign numerical values to the projects; say, Trina is 1, Jinko is 2 etc.

Then format all columns in the tabme (Format, Cell Elements, Background Color, format style, Rules). There, if value =1, then, say, the color green.

[TXT0VBI]

Thank you, I want the gradient coloring and it should change based on the selection of project. If I select Trina project then in column $/Product 3 the values should be gradiently colored according to 614 value i.e. values in $/Product3 below 614 should be gradiently green and the values in $/Product3 above  614 should be gradiently red. Same gradient coloring should happen with other columns based on Trina as well. I also need how to give that selection of each project as well as when I give slicer it is filtering but not selecting that project. I created a new table with Project column alone and trying it but need help how to proceed after that and create a selection.

[AliceW]

I don't think you can condition colors based on two columns.

[TXT0VBI]

Can I give an additional column and give value name 'base' corresponding to the Project row I want to consider as base and give a selection box either from different table or same table to change the value 'base' of the additional column dynamically to the corresponding row based on the selection and give any condition like if the column value is 'base' or not blank then format other values in columns based on this row?

[Anonymous]

@TXT0VBI what is the condition that you want to apply to the column values here?

[TXT0VBI]

If we select Trina then the values $/product1,$/product2,$/product 3 of trina should become the base values then rest of the projects $/product1,$/product2,$/product 3 values should color code according to Trina values