Conditional Formatting
 

I am creating a log to track assignments and holdfiles. If want the
cell containing the holdfile date to turn red if the assignment is not
complete by the holdfile date.

I have a column for holdfile date, a column for comlpeted date, and a
cell with the current date.

So if the completed date is still blank and the holdfile was not met I
want the hold file cell to turn red. If the completed date entered
exceeds the holdfile date I want it to stay red.

All help is greatly appreciated.

Conditional Formatting
 

if the completed date is still blank and the holdfile was not met

That is not very clear.

Here's my interpretation of your post:

A2 = some date
B2 = empty or some date

If A2 has a date and B2 is empty then A2 is RED
If A2 has a date and the date in B2 is greater than the date in A2 then A2
is RED

If my interpretation is correct then do this:

Select A2
Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the box to the right:

=OR(AND(COUNT(A2),A2-B2=A2),AND(COUNT(A2:B2)=2,B2A2))

Click the Format button
Select the style(s) desired
OK out

--
Biff
Microsoft Excel MVP


"japc90" wrote in message
...
I am creating a log to track assignments and holdfiles. If want the
cell containing the holdfile date to turn red if the assignment is not
complete by the holdfile date.

I have a column for holdfile date, a column for comlpeted date, and a
cell with the current date.

So if the completed date is still blank and the holdfile was not met I
want the hold file cell to turn red. If the completed date entered
exceeds the holdfile date I want it to stay red.

All help is greatly appreciated.