Thursday, August 10, 2017

yogi_Conditionally Format Entries In E4:E -- Yellow Red or White Depending On Date Due

Google Spreadsheet   Post  #2223

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Aug-10-2017
question by: Brittany Berridge
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/62Q07ikdCXs;context-place=mydiscussions

Conditional Formatting for due dates

 
Hello, I am setting up a spreadsheet that contains a due date and a date turned in column. I have the conditional formatting set up to highlight the upcoming due dates (7 days out) but I would like the formatting to go away if the 'date turned in' column contains data.