Forum Discussion
Solved
Conditional formatting based on value in another range
I'm trying to format columns A, B, and C based on whether the value in column F is equal to 0. The conditional formatting rules shown result in rows doing just that (although only sometimes) but ...
Change the formula in the rule for columns A to C to
=$F1=0
referring to the first cell in the range.
Change the formula in the rule for columns A to C to
=$F1=0
referring to the first cell in the range.
Hartelijk dank!
This worked for me. I don't understand why, as =$F1=0 appears to mean "if the value in cell $F1 equals 0", but I'll take it.