Friday, October 31, 2014

yogi_Conditionally Format Cells In C2 To C If FollowUp Date Is Blank And It Has Been More Than 30 Days Since Appointment Date

                 Google Spreadsheet   Post  #1812
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-31-2014
post by  Si Leydon:
Hi, I need a cell on google sheets to highlight red if a date hasn't been entered in it within 30 days of the date in another cell. Can you tell me how to do this please?

Thanks for your help.

This is the link to the dummy sheet, basically i want the follow up appointment field to highlight red when it is blank and 30 days after the date in the original appointment. Once a date is entered in the follow up box I then want it go back to the original colour. Is that possible?

Thanks again for your help.