PDA

View Full Version : Solved: Conditional Formatting



U_Shrestha
12-09-2008, 01:21 PM
Hi,

In B13:B26, I have list of numbers ranging from 0.7 to 10.

The range C13:G26 can have the value "NS", "ND" or numbers ranging from 0.1 to infinity. If the number in this cell is greater than its corresponding number in column B, then I want the font to be BOLD RED. If it is less than or equal to its corresponding no. in column B, then I want to see GREEN BOLD color. If the value is ND, then it should appear GREEN BOLD and finally, if it is "NS" then it should remain BLACK font.

With my current conditional formatting, I am getting first 3-conditions met, but if the value is "NS" it appears RED BOLD instead of BLACK font.

This is the current setting:-
1) If cell value is equal to "ND", GREEN font
2) If cell value is greater than =$B13, RED BOLD
3) If cell value is less than equal to =$B13, GREEN font.

Can someone help? I am using MS Excel 2003, so it allows only 3-conditions. Thanks.

Bob Phillips
12-09-2008, 01:38 PM
Change conditions 2 and 3 to Formula Is with formulae of

=AND($B13<$C13,ISNUMBER($C13))

and

=AND($B13>=$C13,ISNUMBER($C13))

U_Shrestha
12-09-2008, 01:47 PM
Perfect solution. Thanks xld :)