Date Passed Notification

L

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?
 
D

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 avoi
that use

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

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?
 
Top