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   Nov-01-2014
post by  Munkey (David):
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.

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