Date Passed Notification

[Lori]

I would like to create a formula that looks at a cell's date, compares it
with a different cell's date. If the different cell has a date prior to the
other cell's date, the text turns red. Is there some way to do that? Perhaps
an If Statement? Can anyone help?

[daddylonglegs]

If you have a date in A1 and want to colour it if it's later (greater) than a date in B1

select A1
use Format > Cells > Conditional formatting
formula is
=A1>B1
apply red pattern

this will also colour A1 if it has a date and B1 is blank, to avoid that use

=(A1>B1)*(B1<>"")

[Lori]

Thank you, That worked like a dream!

"daddylonglegs" wrote:

>
> If you have a date in A1 and want to colour it if it's later (greater)
> than a date in B1
>
> select A1
> use Format > Cells > Conditional formatting
> formula is
> =A1>B1
> apply red pattern
>
> this will also colour A1 if it has a date and B1 is blank, to avoid
> that use
>
> =(A1>B1)*(B1<>"")
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=503113
>
>

[DavidOrtiz]

Is there a way to have the dates that were in red on several sheets (in this case one sheet in the excel file) go to a pop up stating the dates and sheet or a seperate sheet?