The following part is SOLVED:
In my spreadsheet, one of my columns (H) has specific dates for each row. If that date is less than or equal to todays date I would like to fill that whole row with the color green. If that specific date is in the future (more than todays date), I would like to fill that entire row with the color red.
My spreadsheet has hundreds of rows with each row having different dates in the H column. With this conditional formatting it well help us find "expired" rows.
---------------------------------------------------------------------------------------------------
The following part is UNSOLVED (newly added):
QUESTION: Is it possible to have the cells highlighted in yellow if they are in the future, but only 1 year or less (to show upcoming dates)?
-Note that the following formulas work for the above problem (thanks DBY!): The cells are highlighted green =AND($H2<>"",$H2<=TODAY()). Dates in the future are
highlighted in red: =$H2>TODAY().
Thanks in advance!
Best,
privatesinn
Bookmarks