Forum Discussion

Deleted's avatar
Deleted
Mar 29, 2017

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 red formatting.

 

I'm not able to get the "not equal" to cells red - they are all green.

 

Help?

 

Thanks!

4 Replies

    • Deleted's avatar
      Deleted

      Tried that...see attached.  There may be something wrong with how I typed it - please let me know. 

       

       

Resources