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     www.energyefficientbuild.com.    Apr-14, 2015
question by Speech Scamaticus:

https://productforums.google.com/forum/utm_medium=email&utm_source=ba_notification#!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.
 

=today()-912

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.

https://docs.google.com/a/webbering.com/spreadsheets/d/1EiTyfMDyH5PnQXUhAuHmLfBQK4nBKWiyI_H0iFol1Go/edit?usp=sharing

Thanks.

Luke