Wednesday, July 10, 2013

yogi_Set Up A Table To Check Item Availabilty For Current Or Specified Month

                                          Google Spreadsheet   Post  #1279
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul 07, 2013
user Aaron White (!category-topic/docs/spreadsheets/flFdbh4b0hU)
Highlight/Check cells based on current date
I have a list of items available only during certain months, something like this

Item      Jan    Feb     Mar     Apr    ....

Item 1                         x        x
Item 2     x       x          x 
I'd like to check the current month (probably using NOW( ) ) and check the cells under each month to see if that item is available. The best I've been able to do so far is to create a bunch of IF statements  for each month, checking if the current month matches using NOW(), then checking to see if the cell under it is empty or not, but it's just a mess. I suspect/hope there's a better way to do it.

Ideally I'd like to change the background color of an item's name during the months each is available, but if that's unfeasible having a dynamic "available" column out front with a check is fine.