J
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.
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.