Sorry, here's some clarification.
I currently have the first conditional working (if the date in the cell is
less than TODAY(), make the cell red.), but it turns all the cells red,
including the blanks ones.
The conditionals below were my attempts at making the blank cells white.
I need help turning the red cells to white if the cell is blank.
"Jason Morin" wrote:
=E8<TODAY()
HTH
Jason
Atlanta, GA
-----Original Message-----
i'm trying to do the following conditional formatting:
if the date in the cell is less than TODAY(), make the
cell red.
if the cell is blank, leave the cell blank with white
shading.
i've tried the following:
cell value is equal to =""
cell value is equal to ""
formula is =AND(E8="",E8<TODAY())
and some others that i can't remember at the moment.
i've searched this forum and tried all the ideas i could
find. anyone have
any other ideas?
.
|