Color cells when Date is current or nearing

  • Thread starter Thread starter dsmith7265
  • Start date Start date
D

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
 
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.
 
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
 
Back
Top