New to sheets so would appreciate any assistance, unable to find appropriate guidance so far online.
I want to conditional format cells in one column based on the dates in another - and repeat the conditional formatting down all rows. I.E
Column A Column B Column C
Date submitted Target Actual
10/10/16 10/17/16(Col.A+7) 10/15/16
I want to format column B (target date) based on content of column C (actual date). If actual date is:
- on or before target - conditional format cell green,
- after target date - conditional format cell red.
- blank - no conditional format
I then want to ensure the same rule applies to all rows individually, without the condition being driven from the first row. Each row will be separate non-related items for date tracking.
Thanks in advance.