Google Spreadsheet Post #1946
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-14, 2015
question by Speech Scamaticus:
On a test spreadsheet, I have created a range for $B$3 to $B$3 called TemplateUpdate as this is the date I want to know if any of my clients last template update is before this date. FYI, I do biennial website redesigns on all clients and need to know if one is past due to be updated. :)
So I created a conditional for a cell that contains the last date I updated a template for a client. It format cells with a color if 'Date is before' 'exact date...' 'TemplateUpdate'. All of the cells in the range B5:9 are formatted with the color yet only 1 of those cells, $B$5 has a date that ie before TemplateUpdate.
Here is a link to the shared spreadsheet if anyone can tell me how to get this so that only cell $B$5 has the 'mauve' background color.