Saturday, November 1, 2014

yogi_Conditionally Format Days Of Month In A Calendar On Matching Specified Dates And Associated Attributes

                 Google Spreadsheet   Post  #1815
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-01-2014
post by  Munkey (David):
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/7Zw2NolazXM)
Conditional formatting - Colour a calendar spreadsheet based on date and an adjacent value
Hello all :)

Hope we're all fine and good?? It's been a while since I've posted, life has been a bit crazy.
I'm not dead, much the opposite, alive and kicking and our first son arrived safe and well 6 weeks ago.
All the crazy preparing and moving home was all worth it :)

Sadly I'm back at work and stumped on a problem.

https://docs.google.com/spreadsheets/d/1XHTMLb38x57jgeOjaiD98S1VaVRXShYCuwMZZOwwlak/edit?usp=sharing

Basically looking to setup some sort of calendar tracker thingy.

I'd like to colour dates in the calendar based on other values in columns Z  & AA

If i do a custom conditional formatting in one of the calendar cells, I can get it to work, but not across the whole range.
It'd be a lot of typing to apply it to 365 cells

I could go down the script route, but that would possibly take me longer than the 365 formula's itself lol

Thanks
--------------------------------------------------------------------------------------------------------------------------------------