Trying to format a cell to change to red when two other groups of cells dont equal each other. So the scenario is I am a sum of 9 cells that should equal the sum shown in ONE seperate cell. I then want a third cell to be displayed as red when the sums of these two other cell groups do not equal each other....
Is there a way in conditional formatting to state where you fill in the formula "does not equal"?
Hello Nightshift,
apply a conditional format to the cell you want to change color (New rule - use a formula to determine...)
The formula should be along the lines of
=Sum($A$1:$A$9)<>$B$1
where A1:A9 are the 9 cells whose sum you want to compare with B1, the other separate cell. Don't forget to click the Format button to apply a color.
If that does not help, please provide a workbook with some sample data.
ahhh yep that works! thanks again for your help! much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks