Re: Alerting imminent dates in excel using conditional formatting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Tel Wrote:

Therefore:
if today is more than 60 days prior to review date then no formatting
if today is between 60 to 31 days prior to the review date then the
cell
will be green
if today is between 30 - 1 day prior to the review date then the cell
will
be amber
if today is either 0 or past the review date then the cell will be red



Highlight the cells with the dates.

Select Format\Conditional Formatting

You can set your criteria by selecting Cell Value Is\
Between\=now()+31\=now()+60 etc.

Play around with it and you will work it out.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35514
View this thread: http://www.excelforum.com/showthread.php?threadid=553568

.

Relevant Pages

  • Re: VLookup #VALUE! error help needed to resolve
    ... I had checked the formatting of all sections prior to sending this question ... Then I copied a cell below where the ... in your reference col F data. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Date Function
    ... formatting to include not only 2 months prior but also 2 months in advance, ... > Hi Dee, ... >> I want to put conditional formatting into a cell where I want excel to change ... >> and 2 months prior to today's date. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: alert in cell
    ... > prior to a date shown in a cell? ... a due date is in the cell and I would need lead time on that date. ... Select A1, choose Format/Conditional Formatting... ...
    (microsoft.public.mac.office.excel)
  • Re: The experts all agree
    ... point you to a few review papers. ... the cell" gets 31k hits, of which 5k are review papers.) ... (Note that you should use the PMID to find the author's names, ... Eukaryotic evolution, changes and challenges. ...
    (talk.origins)
  • RE: What function
    ... In the prioir month worksheet are the serial numbers for the prior month. ... Let's assume your range of values from the prior month is on a sheet named ... then you can use conditional formatting to change the color of the ... cell or font to let you know that they are different. ...
    (microsoft.public.excel.worksheet.functions)