Forum Discussion
Anonymous
Mar 29, 2017conditional 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 red formatting.
I'm not able to get the "not equal" to cells red - they are all green.
Help?
Thanks!
4 Replies
Sort By
- SergeiBaklanDiamond Contributor
Hi Beth,
Like
=($A1:$A40<>$B$1)
in Conditional formatting formula
- Anonymous
- SergeiBaklanDiamond Contributor
Instead of $J$4 please use $J4.
=($J4<>$H$4)