Conditional Format: Expired dates wanting cell to change color
 

Hi-lite all of the cells that might have overdue in them and then use
conditonal formatting. Format....conditonal format....cell value: is equal
to overdue
then click on the format area and choose yellow for the font and red for the
pattern



"Dan" wrote:

I have a chart that displays when tasks have been completed, when they are
due, and at what interval the task is required to be renewed by. My question
is i want the cell of the due date to change to red and for the text
"overdue" to be in yellow, when that due date goes past the interval of when
it was completed by.

If anyone can help me get out of this bind i would appreciate it

Dan

Conditional Format: Expired dates wanting cell to change color
 

I have a chart that displays when tasks have been completed, when they are
due, and at what interval the task is required to be renewed by. My question
is i want the cell of the due date to change to red and for the text
"overdue" to be in yellow, when that due date goes past the interval of when
it was completed by.

If anyone can help me get out of this bind i would appreciate it

Dan