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     www.energyefficientbuild.com.   Oct-31-2014
post by  Si Leydon:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/kWXqDRJ2Di8)
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.
---
https://docs.google.com/spreadsheets/d/1GexCXCIz0HRYeSPEZCxBkFFgPVWSF3YWM1ndEfs9-ps/edit?usp=sharing

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.
--------------------------------------------------------------------------------------------------------------------------------------------------