Monday, September 25, 2017

yogi_Conditionally Format column B If column A Date Is Equal To Or Greater Than Today's Date By 1 Year

Google Spreadsheet   Post  #2247

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-25-2017
question by: Homestead Help!topic/docs/uL6otiR9PNs;context-place=forum/docs
Conditional Formatting with two sells
What I am trying to do is make a cell change color when another cell is a certain date. Example:

I want for a cell to change if the other cell is one year away from today. 
If cell A is equal to or greater than one year of today's date I want cell B to change green. 

I thought this was going to be easier than it is turning out to be...