Try just doing it for the entire column starting with H1, because it works
perfectly on my spreadsheet. It only highlights values that are today through
2 months... and leaves all text and other dates alone.

"Sunset" wrote:

Seems to be the right direction, although the boxes that highlighted either
have no information or are dated 12-30-2007. The column is the "H" beginning
with row "7"

"AKphidelt" wrote:

Hey, try this... it should work by highlighting the cells that are within two
months away. Select the column that has the dates.... then go to

Format--- Conditional Formatting

Then change Condition 1 to---- Formula is

And in the Formula Box type

=AND(A1-TODAY()<60,A1-TODAY()0)

REMEMBER**** you have to Change A1 to whereever your first date starts. So
if your dates are in column H... you will change the A1s to H1s, etc.

"Sunset" wrote:

I have a spreadsheet that shows contract begin and end dates. I would like
the end date to highlight or change colors when it is two months away.