Tuesday, April 24, 2012

yogi_Work Around For Conditionally Formatting Dates In A Column Based on A Formula-1

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #514    Apr 24, 2012     www.energyefficientbuild.com.

user GavinP said: 
I require the cell to turn red if the date is any time between today and 20 days in the future. For example, today is 24/04/2012, so I need the cell to be red if the date is between 25/04/2012 and 14/05/2012 (20 days in the future). The spreadsheet is designed to warn me if a date has either passed or is coming up 20 days in the future. 
following is a solution to the problem -- Please note that I changed TODAY to specified date to have generalized solution This solution is an extension to the solution I had posted in response to the user's similar question -- see my blog post: http://yogi--anand-consulting.blogspot.com/2012/04/yogiwork-around-for-conditionally.html