Forum Discussion
conditional formatting where there are an equal to and a not equal for the same cells in a column
I'm trying to format a column of numbers comparing them to a static number (deduction amount to benefit elected amount. If they are the same, I want the formatting in green - if they are not, I want...
Hi Beth,
Like
=($A1:$A40<>$B$1)
in Conditional formatting formula
Tried that...see attached. There may be something wrong with how I typed it - please let me know.
Instead of $J$4 please use $J4.
=($J4<>$H$4)
That did it - thank you!