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?

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
=A1B1
apply red pattern

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

=(A1B1)*(B1<"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503113

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
=A1B1
apply red pattern

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

=(A1B1)*(B1<"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503113

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?


--
DavidOrtiz
------------------------------------------------------------------------
DavidOrtiz's Profile: http://www.excelforum.com/member.php...o&userid=33416
View this thread: http://www.excelforum.com/showthread...hreadid=503113