Friday, April 17, 2015

yogi_Conditionally Format Cells In B5:B If Date In B5:B Is Before Template Update Date In Cell B3

                                           Google Spreadsheet   Post  #1946
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr-14, 2015
question by Speech Scamaticus:!category-topic/docs/spreadsheets/oGSAqVChq84
Conditional Format based on date less than a calculated date name range
I have in $K$5 cell a calculations for a date 2 1/2 years before the current date which does give me the date I want.

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.