Flag a cell for over year from date inputted.

[karlaspalms]

I need the cell for any date that is over one year to turn red. I cannot for the life of me figure it out. I am using Excel 2010.

[dredwolf]

Assuming the cell is A1 ( or the first cell in the range of cells is A1):
Select the cell (or range of cells), Goto Home tab on Ribbon menu, select Conditional Formatting, select New Rule, select Use Formula, in the Format values where this formula is true put this formula in :
=(Today()- A1)>365
select Format, select Fill..select a color...Hit OK,OK

Hope this helps

[karlaspalms]

Hi I was able to get it to work. Howeever, I have a question to add. When I put in the formula and their are some blank cells due to no date data it fills those cells red, even though they do not yet have a date. How can i keep the cells with no data from filling with red?

I added an example.

Thank you for your help.

[dredwolf]

High-light the range again, then in CF goto Manage Rules, edit the rule and change the formula to this :

Please Login or Register  to view this content.

Hope this Helps

[karlaspalms]

Thank you so much for your time. You have been AWESOME help.

[dredwolf]

You are welcome
Thank you for the kind words !

Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"