Conditional formatting referencing date of expiration
 

I'm trying to apply conditional formatting to a cell, to show it has expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however the
conditional formatting changes immediately even though the two cells are not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should apply.

Conditional formatting referencing date of expiration
 

Try this:

Select cell A2
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=A2=$G$5

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
I'm trying to apply conditional formatting to a cell, to show it has
expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however the
conditional formatting changes immediately even though the two cells are
not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should
apply.

Conditional formatting referencing date of expiration
 

Okay, that worked! but my next problem... it is only applying the formula if
the dates are EXACTLY the same... can i make it so if it is today or any day
AFTER today it will continue the formatting??

"T. Valko" wrote:

Try this:

Select cell A2
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=A2=$G$5

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
I'm trying to apply conditional formatting to a cell, to show it has
expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however the
conditional formatting changes immediately even though the two cells are
not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should
apply.

Conditional formatting referencing date of expiration
 

If I understand, change the formula to:

=A2<=$G$5

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
Okay, that worked! but my next problem... it is only applying the formula
if
the dates are EXACTLY the same... can i make it so if it is today or any
day
AFTER today it will continue the formatting??

"T. Valko" wrote:

Try this:

Select cell A2
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=A2=$G$5

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
I'm trying to apply conditional formatting to a cell, to show it has
expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however the
conditional formatting changes immediately even though the two cells
are
not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should
apply.

Conditional formatting referencing date of expiration
 

THAT WORKED!!!
THANK YOU!


Any chance you have a 'cheat sheet' for formulas handy or know where i can
find one? :-)

"T. Valko" wrote:

If I understand, change the formula to:

=A2<=$G$5

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
Okay, that worked! but my next problem... it is only applying the formula
if
the dates are EXACTLY the same... can i make it so if it is today or any
day
AFTER today it will continue the formatting??

"T. Valko" wrote:

Try this:

Select cell A2
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=A2=$G$5

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
I'm trying to apply conditional formatting to a cell, to show it has
expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however the
conditional formatting changes immediately even though the two cells
are
not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should
apply.

Conditional formatting referencing date of expiration
 

You're welcome!

Any chance you have a 'cheat sheet' for formulas handy or know where i can
find one?

Maybe this:

http://homepage.ntlworld.com/noneley/

I do something similar except I keep a library of formulas in separate files
and I tend to only "catalogue" the really complex formulas. Right now I have
349 sample files and each file contains dozens of formula variations.

One of these days I'd like to compile all these formulas into a book or do
something similar to what Peter did.

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
THAT WORKED!!!
THANK YOU!


Any chance you have a 'cheat sheet' for formulas handy or know where i can
find one? :-)

"T. Valko" wrote:

If I understand, change the formula to:

=A2<=$G$5

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
Okay, that worked! but my next problem... it is only applying the
formula
if
the dates are EXACTLY the same... can i make it so if it is today or
any
day
AFTER today it will continue the formatting??

"T. Valko" wrote:

Try this:

Select cell A2
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=A2=$G$5

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"FIRE GIRL" wrote in message
...
I'm trying to apply conditional formatting to a cell, to show it has
expired
when today's date equals the date of expiration.

I have the =today() formula in a cell for reference, however
the
conditional formatting changes immediately even though the two cells
are
not
equal..

What am i doing wrong??
example:

cell A2 is the date of expiration- 7-1-2012
cell G5 is today's date- 8-15-2008

when they are equal to each other, the conditional formatting should
apply.