Conditional Formatting (Dates)

D

d_birr77

I can't wrap my head around this conditional formatting stuff.

Is it possible to do the following?

My F3 cell contains a date. If F3 is greater than or equal to 1 year, I
want my A3 cell to be colored yellow.

Any help would be greatly appreciated.
 
B

Biff

Hi!

If F3 contains a date greater than 12/31/1900, then it's going to be greater
than or equal to 1 year.

I think a better explanation is needed!

Biff
 
D

d_birr77

Oops !!

I have a date entered in F3 (example: 2003/01/20). If from today's date, F3
is more than one year, then I want A1 to be colored yellow.

EX1: Today's date is 2005/07/18 - the date entered in F3 is 2005/06/07 -
(less than one year) - I don't want A1 colored yellow.

EX2: Today's date is 2005/07/18 - the date entered in F3 is 2004/06/07 -
(more than one year) - I do want A1 colored yellow.

I hope this clarifies.

Thanks in advance.
 
B

Biff

OK....

Select cell A1
Goto Format>Conditional Formatting
Formula is: =TODAY()-365>$F$3
Click the Format button and select the style you'd like
OK out

Since leap years have 366 days, do you want to account for that or will the
"standard" year suffice?

Biff
 
B

Biff

After thinking about it, it may be more overly complicated then I first
thought and in the end may be a useless endeavor.

Seems to me it would only appy if TODAY() is Feb 29 or after of a leap year
in which case you'd subtract 366 days.

That's the problem we sometimes run into working with dates. How many days
are in a year? How many days are in a month? Week numbers are a nightmare!

Biff
 
D

d_birr77

No worries. I got the spreadsheet working the way I wanted it to.

I want to thank you for your help.
 
Top