Formula results to be highlighted through IF function?

  • Thread starter Thread starter russ68
  • Start date Start date
R

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
 
hi
read up on conditional formating. i think that is what you are after.

regards
FSt1
 
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'.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Conditional Formatting - Comparative Versus Other Cells 4
Conditional formatting referencing multiple cells. 2
highlight cell 1
Total a column (or row0 by highlighting cells 1
formatting excel date list 5
formula to track timeframe by automatically highlighting cells 6

Back
Top