LinkBack URL
About LinkBacks
How do you put the phrase "does not equal" into excel language? I want to conditionally format using "if this cell doesn't equal another cell."
How do you put the phrase "does not equal" into excel language? I want to conditionally format using "if this cell doesn't equal another cell."
<> will do it
not a professional, just trying to assist.....
OK, so I thought that would fix it, but it hasn't. Help? My formula is supposed to be if the sum of cells ABCD does not equal cell E, then change cell F to color red. If it does equal, then change to green. HELP!
Anyone know?
You have two conditions to set in your Conditional Format for cell F1:
Condition 1:
Formula is: =SUM($A$1:$D$1)=$E$1 set your Pattern Fill color to Green
Condition 2:
=SUM($A$1:$D$1)<>$E$1 set your Pattern Fill color to Red
You may also need to alter your font color to have it show up better in your display
HTH
Bruce
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks