How to create a formula in Excel to highlight dates?

Question

Hello all:

I keep track of hundreds of vehicle registration expiration dates in Excel. I need to create a formula which will:

1) highlight (fill with color, actually) the cell with yellow when the date within the cell occurs in the next five days and

2) then highlight the cell in red when the date has passed.

This will allow me to see, at a glance, which registrations are coming due very soon, and which have already expired.

Thanks in advance!

Answer 1

If conditional Formatting did not worked for you or you need more info for it, mail me here in Y! Answers

Enjoy my profile, I am the VBAXLMan

Answer 2

Use Conditional Formatting option.

If you want to know more about conditional formatting and how to use it - just message me at [e-mail]

did you check out this website www.ExcelGoodies.Com , they teach u excel online (instructor led training) May be u can try learning from them as well..

Answer 3

those classes might assist you to: a million. choose all the suitable cells in C. 2. swap on format|Conditional Formatting. 3. choose "decrease than" from the container next to the "cellular cost Is" container. 4. swap on format. 5. choose yellow from the kinds tab. 6. supply ok, ok.

Answer 4

Use conditional formatting instead