Google Spreadsheet Post #2528
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Oct-26-2018
question by: Anthony Coates
https://productforums.google.com/forum/#!topic/docs/1J2QLZ1QZSc;context-place=forum/docs
https://productforums.google.com/forum/#!topic/docs/1J2QLZ1QZSc;context-place=forum/docs
Payment Tracker due date conditional formatting
Hi,
Looking for some help with regards to conditional formatting, I am setting up a sheet to track payments, however I am having trouble with conditional formatting, I've googled but can't seem to find what I am looking for..ill try to explain what I want to do, below.
So I have a column (D) that contains the payment due dates (this date could vary depending on circumstances), what I want to do is -
15 days before the payment due date have the cells highlighted yellow
5 days before the payment due date have the cells highlight amber / orange
If its after the due date, then highlight red
However if the value of a cell corresponding cell in column E is yes, then highlight the cell green (So if the due date is in D2 and the value Yes is in E2 then D2 highlights green and it ignores any of the other formatting mentioned above,
A link to the document can be found here -
https://docs.google.com/
No comments:
Post a Comment