Conditional Formatting

[japc90]

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.

 

[T. Valko]

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 Format>Conditional 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,B2>A2))

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