color coding dates

[Becca111]

I have a spreadsheet set up that tracks employees and their training dates. I go into the spreadsheet periodically and highlight expired trainings yellow. Is there a way to make the cells automatically turn yellow if the date is past today?

 

[Andrew Poulsom]

Welcome to MrExcel.

You can use Conditional Formatting with a formula like:

=A1 < TODAY()
<TODAY()

Change the cell reference to suit.

 

[Becca111]

thank you for replying, so where do I put the color in at?

 

[Andrew Poulsom]

In Conditional Formatting you click the Format button:

Excel Conditional Formatting Introduction

 

[Becca111]

Yeah! Thank you so much! I never would have found that on my own. Thank you, Thank you, Thank you!!

 

[Becca111]

I just wanted to say thank you again. Thank You! I have formated all of my spreadsheets now for differant "conditions" Its WONDERFUL! Everone in the office now knows about conditional formating!

 

[Andrew Poulsom]

You are welcome!