Date Passed Notification
 

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?

Date Passed Notification
 

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

Date Passed Notification
 

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

Date Passed Notification
 

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