Forum Discussion
Conditional Formatting Using Formulas
I am trying to highlight cells yellow in columns E, H, K, N.......AO based on whether the value is lower than the value in columns C, F, I, L......AM. (eg. If E7<C7, H7<F7...........) I selected the...
Make sure that E7 is the active cell in the selection (use Tab if it isn't).
Then use the formula =E7<C7 (without $ signs)