Problem in Formatting

[ajxxx]

The only problem with the file is the column on the right hand side that is always red even if there are no customers on the left hand side.

Basically, the file starts on the left side once someone gives a deposit. The date is hand written into the field underneath the proper heading. But I can't get rid of the RED colour on the right side. Red should appear if something is wrong only. But it is showing red for every line item.

[teylyn]

Hi, try setting the formatting rules with the option "use a formula to determine which cells to format" and apply these rules in this order:

=$J5="" -- no formatting
=$J5<21 -- green
=$J5>21 -- red

The order of formatting rules is important if Excel is told to stop evaluating when true. Also, for some reason, the test for J5>21 returns TRUE for the cell that appears blank but contains the formula

=IF(E5="","",E5-B5)

Don't really know why ....

hth

[martindwilson]

looks like "" is always higher that any number. try in a1 ="" in b1 =a1>anynumber you like ,returns true