Conditional formatting refrences/validity
Posted by George J on February 07, 2002 6:26 AM
I have a spreadsheet in which cell f2 is a date based on the formula =IF(C2<TODAY(),DATE(YEAR(C2)+G2,MONTH(C2),DAY(C2)),C2) with c2 being a date and g2 the no. of years in advance.
I want cell f2 (or the entire row if possible) to turn red if the date in f2 is less than today()
I entered =F2<TODAY()
I also want cell f2 (or the entire row) to turn green if the date is within the next year.
I entered =AND(F2>=TODAY(),F2<=edate(TODAY(),12))
This does not work.
As I intend to create a macro (somehow) that will show on another sheet all the properties between the date in f2 and a year from then, what is my best course of action?
Will i need to enter even more macros instead of conditional formatting?