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.

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_birr77" wrote in message
...
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.

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.


"Biff" wrote:

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_birr77" wrote in message
...
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.

OK....

Select cell A1
Goto FormatConditional 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

"d_birr77" wrote in message
...
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.


"Biff" wrote:

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_birr77" wrote in message
...
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.

What change needs to be made to account for leap years?



"Biff" wrote:

OK....

Select cell A1
Goto FormatConditional 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

"d_birr77" wrote in message
...
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.


"Biff" wrote:

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_birr77" wrote in message
...
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.

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_birr77" wrote in message
...
What change needs to be made to account for leap years?



"Biff" wrote:

OK....

Select cell A1
Goto FormatConditional 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

"d_birr77" wrote in message
...
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.


"Biff" wrote:

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_birr77" wrote in message
...
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.