Monday, September 21, 2015

Conditional Formatting Of Dates in Column D That Are Past Due Date

Google Spreadsheet   Post  #1977
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-21-2015
post by  jrose31018:)
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/a-PF2GiyIkE
Conditional formatting of due dates
Hi!
I'm having problem with formatting some due date in a specific cell. What i want to do is the cell (cell D) background would turn red when its already past the due date, also it would'nt change to red if in cell E an advance date is inputed. But it would still have a red background if its past due and the date in cell E being inputed is way past the due date too.

Thanks
---


jrose31018 said: