Hello. I am trying to add on a feature to product i created. Right now, i have conditional formatting set up, so that if the due date is past the current date, that cell turns red. But what i would like to add, is that if the user completes the task /enters in the required score, then change the cell back to no-color. I have been searching for hints on the internet, but can't find the 'or' or 'and' formula that will work here.
I am adding an example of the worksheet for your review.
thanks. FJ
Bookmarks