Formula results to be highlighted through IF function?

[russ68]

I have a column displaying number of days to go to an event.

I undertand that I can automatically highlight this number if less than a
pre-set amount of days.

Thanks

 

[FSt1]

hi
read up on conditional formating. i think that is what you are after.

regards
FSt1

 

[Alan Moseley]

Highlight your relevant cells or column and click Format, Conditional
Formatting. Where it says 'Condition 1' leave the box below to say 'Cell
Value Is'. Change the next box to say 'less than', and in the third box type
in the number to be less than. Now click the 'Format' Button and go to the
'Patterns' tab. Choose a highlight colour and click 'OK'. Finally click
'OK'.