IF Formula to produce coloured statements
Kylii,
A worksheet formula cannot effect a change on the formatting (or any
other part, for that matter) of the sheet itself, it can only return a
value to the cell in which it resides. In order to achieve the effect
you are describing you need to look at Conditional Formatting in the
Format menu and in help.
Hth,
O
|