Forum Discussion
Formatting through sheets
Hello, I have a problem that I am unable to solve. I have two identical tables on two sheets, but with different values. I have conditional formatting on Sheet2 that divides my cells by color. I nee...
=sheet2!A1>20In the example there is this rule for conditional formatting in sheet1 that refers to the values of sheet2.
=$A$1:$E$10The "applies to" range refers to the same cells in both sheets.
Then the values in sheet1 are formatted according to the values from sheet2 in my sample file.
Sheet1:
Sheet2:
OliverScheurich Thank You, that´s nice, but I still can´t use it for my need. My conditional formating is based on a color scale with the smallest number in green, the percentile in yellow and the highest number in red. So there is no formula that has a True/False result.