If someone could help me out with some conditional formatting help I would be eternally grateful.
B9 has a formula of =-SUM('SHEET1'!C8:C20)
B10 has a formula of =-SUM('SHEET2'!C8:C20)
I am trying to apply the following three conditional formatting formulas to both B9 and B10:
=AND(SUM(B9,B10)<=-400,B9<=0,B10<=0)
[which turns the cell/s red]
=AND(SUM(B9,B10)<=-200,SUM(B9,B10)>-400,B9>-400,B10>-400)
[which turns the cell/s yellow]
=AND(SUM(B9,B10)>-200,B9>-200,B10>-200)
[which turns the cell/s green]
B9 reacts correctly in all situations, regardless of the value of B10 (whether it is 0 or any other number less than 0)
B10 however does not change colors to yellow when the value of the SUM is less than -200 unless B10 itself has a value of less than -200 (and the same is true for red and -400).
[EX: if B9 is -201, B10 still shows up as green.]
Does anyone have any suggestions?
Thanks, hwl214
Hi,
Have you entered the conditional format manually for each cell? If so, there may have been a typo somewhere.
Or have you copied the cell with the format? Then absolute and relative cell referencing may be the reason.
You could try the following:
in cell B9 check that your cell references in the CF are absolute, i.e. use the $B$9 and $B$10 instead of just B9 and B10
check that B9 is still formatting OK
click on cell B9
click the format painter
click the cell where you want the same condition to apply (B10??)
Now they should both work the same because they both have the exact same conditional format settings.
HTH
Teylyn
Last edited by teylyn; 12-02-2008 at 07:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks