Sunday, March 25, 2018

yogi_Using Indirect Function with Conditional Formatting

Google Spreadsheet   Post  #2405

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-25-2018
Using Indirect Function with Conditional Formatting
I'm trying to color the cells in column G in Sheet3 based on the value of the corresponding cell in Sheet4.

If the value for a cell in Sheet4 is 1, then I'd like the corresponding cell in Sheet3 to be green. If the value is zero, then the color should be set to red.

For example, for G2 Sheet3, "Prom" should be colored green because the value for G2 Sheet4 is 1.

I've been experinmenting with G2 Sheet 3 using:

=indirect("Sheet4!G2")="1"

as a custom formula within conditional formatting, but no luck.

I haven't tried the formula for the red yet, but G5 Sheet3, for example should be red, as the value for G5 Sheet 4 is 0.