N
NikiT
I have a multiple page project checklist that will be completed daily
by the staff. There is a Deadline Date column with a predetermined
deadline filled in. The next column (completion date) needs to be
completed by the staff with the date the task was completed. I would
like the cells that need to be completed to be pale green if an entry
needs to be made and turn red if the completion date is past the due
date (when no entry has been made yet). Once a date is entered in the
cell, I would like to date to be normal font and text color if on or
before deadline and red font if after the deadline.
I have been able to get several of the conditions set correctly, but
cannot get all to work together.
Can someone write out how many conditions I need to set up and in
which order if an order is needed?
by the staff. There is a Deadline Date column with a predetermined
deadline filled in. The next column (completion date) needs to be
completed by the staff with the date the task was completed. I would
like the cells that need to be completed to be pale green if an entry
needs to be made and turn red if the completion date is past the due
date (when no entry has been made yet). Once a date is entered in the
cell, I would like to date to be normal font and text color if on or
before deadline and red font if after the deadline.
I have been able to get several of the conditions set correctly, but
cannot get all to work together.
Can someone write out how many conditions I need to set up and in
which order if an order is needed?