#1
|
|||
|
|||
Question
Hello,
I have a column with dates (day/month/year format) For each date (row) I want that if that date is older than 4 years the cell goes red. Otherwise goes green. So basically it is just comparing the date introduced with the current system date. If older than 4 years cell goes red, otherwise goes green. Is that possible with Excel 2007? Cheers |
#2
|
||||
|
||||
Hi and welcome to the board
Supposing your date is in A1 enter the following conditions for RED : =A1<DATE(YEAR(TODAY())-4,MONTH(TODAY()),DAY(TODAY())) GREEN =A1<>"" Cell will stay default color if empty |
#3
|
|||
|
|||
Quote:
Thx |
#4
|
||||
|
||||
Use the Home ribbon - conditional formatting - New rule - use the " formula is" option
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ppt question | fat | PowerPoint | 0 | 10-06-2011 01:33 PM |
Hypertext Question | Juc1 | Word | 6 | 05-05-2011 06:09 AM |
One to many and many to one question | Girlie4 | Excel | 3 | 08-09-2009 08:02 PM |
Need help with this question... | lllDNYlll | Outlook | 0 | 05-04-2006 07:17 AM |
Categories question & replying with attachment question | glitzymama | Outlook | 0 | 03-15-2006 09:32 AM |