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.