J
John
Column A is the date a project was assigned.
Column B has the date the project is due.
Column C is the date the project was completed.
Column D is the number of days remaining before the
project is due. (date project due-now)
I want the text in column D to be:
black if greater than or equal to zero and C is null.
red if it is a negative number and C is null.
white if c is not null
How do I set up the conditional formating to do this?
Column B has the date the project is due.
Column C is the date the project was completed.
Column D is the number of days remaining before the
project is due. (date project due-now)
I want the text in column D to be:
black if greater than or equal to zero and C is null.
red if it is a negative number and C is null.
white if c is not null
How do I set up the conditional formating to do this?