Conditional Formating Question

[bill4364]

Hey,

I am making a matrix that tracks the the deliverables of a long project. So lets say I have the expected start and end date of all the phases of the project in column A and B respectfully and columns C and D are blank but are to be filled out with the realized dates that phases of the project are started and completed.

So for these blank cells (those in C & D) I need to set up formating for 3 different conditions, and the first two are simple: Green background if the realized start date is equal to or before the target start (C<=A), and red background if it is after (C>=A).

Now the third is what is not so straight forward, I want the cell to be red if the cell is blank and the date is after the target start date which is what I cannot figure out how to do.

I want the cell to be left blank up until the time to add the date a phase is started/finished because that is how one can quickly tell how far along in the project the program is, but I don't know how to conditionally format the cell to be a certain color in the condition that a different cell is greater than another (C formated red if E>A with E being a cell with =TODAY() in other words)

Any one want to help me out??

 

[Marcelo Branco]

If i understood correctly, maybe this

=AND(C1="",TODAY()>A1)

HTH

M.

 

[bill4364]

You understood perfectly and just saved me a ton of time. I didn't know about the and function, thats a useful one

 

[Marcelo Branco]

You understood perfectly and just saved me a ton of time. I didn't know about the and function, thats a useful one

Tks for the feedback

M.

 

[bill4364]

Thanks for the help