Conditional formatting: text color

  • Thread starter Thread starter John
  • Start date Start date
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?
 
Select the control (column d) and click Format on the tool
bar, then conditional formatting. For each condition, use
the drop down and select Expression Is and here are the
expressions. You will need to replace what I have in
brackets with your field names.


[projectcompleted] Is Null And [DaysRemaining]>=0 ---
change font color to black

[projectcompleted] Is Null And [DaysRemaining]<0 ---
change font color to red

[projectcompleted] Is Not Null ---- change font color to
white
 
Thanks for the help Loretta!
-----Original Message-----
Select the control (column d) and click Format on the tool
bar, then conditional formatting. For each condition, use
the drop down and select Expression Is and here are the
expressions. You will need to replace what I have in
brackets with your field names.


[projectcompleted] Is Null And [DaysRemaining]>=0 ---
change font color to black

[projectcompleted] Is Null And [DaysRemaining]<0 ---
change font color to red

[projectcompleted] Is Not Null ---- change font color to
white
-----Original Message-----
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?
.
Click to expand...
.
Click to expand...
 
Back
Top