title: Conditional formatting based on date in another cell
body: <p>I have text in cell A1 that I want to apply conditional formatting to based on the dates in cells A2:A5.  That is if a date in A2:A5 is older than today I want A1 to be filled in red.  If the date in A2:A5 is less than 30 days from today I want A1 to be orange.  I have tried various formulas and just cant seem to get it to work.  Appreciate any help.  Thanks</p>