Color cells when Date is current or nearing

[dsmith7265]

Hello all, I was wondering if anyone could tell me how to color a cell
when a date nears or is the same date. Is this possible?


Thanks!
DLS

 

[J.E. McGimpsey]

Take a look at Conditional Formatting in XL Help.

You probably want your condition to read something like:

Formula Is =(TODAY()-5)< A1

this assumes that A1 is the cell you're conditionally formatting and
that you want the cell colored if the current date is later than 5
days prior to the value in A1. After you enter the formula, click on
Format and select a color from the Patterns tab, then click OK, OK.

 

[Peo Sjoblom]

Format>conditional formatting, formula is

=AND(A1-TODAY()<5,TODAY()<=A1)

where A1 is the date, I used less than 5 days, change that to what you want

 

[billQ]

Try to set a formula comparing date using the conditional formatting.
bill