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 when the cell value in F is NOT 0 and never when the cell value is F IS 0.
I don't know how to troubleshoot this. If you know why Excel displays this behavior, please respond in this thread.
Thank you.
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.
