We are scheduling nurses for continuing education by putting a target date into a cell that we want to turn red when that date hits a 7 day threshold. Then when the RN completes that module of education, on a date that will be in the adjacent cell; we want that target date cell to revert to standard black text. It looks like a rule will have to be made that depends on the target date cell and its relationship to the completed date cell.