Conditional Formatting in Excel 97

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

I am trying to set-up a conditonal formatting for a date
and my guess is that I will have to use a formula rather
than a cell value, however, I don't know how to do that.

I have a start date e.g. 01/01/03 and if that exceeds 1
year (on 02/01/04) than I want the date to change let's
say in red.

Is this possible without having to add further columns to
calculate the days left (e.g. =DAYS360(TODAY(),D4) first?

Any ideas?
 
Nicole said:
I am trying to set-up a conditonal formatting for a date
and my guess is that I will have to use a formula rather
than a cell value, however, I don't know how to do that.

I have a start date e.g. 01/01/03 and if that exceeds 1
year (on 02/01/04) than I want the date to change let's
say in red.

Is this possible without having to add further columns to
calculate the days left (e.g. =DAYS360(TODAY(),D4) first?

Any ideas?
Click to expand...

Nicole, this may do the trick

Select conditional formatting

In the left hand box it says Cell value - change that to formula by clicking
on the black arrow

Then in the right hand box that appears put =Today()>Date(2004,1,1)

Alternatively, you can use your formula above, slightly modified, viz:

=DAYS360(TODAY(),D4) > 360

Geoff
 
Nicole,

You are right you need a formula.

In CF, add this formula

=TODAY()>DATE(YEAR(D4)+1,MONTH(D4),DAY(D4))

assuming D4 has your start date


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Many thanks for your help. I had tried =DAYS360(TODAY
(),D4) > 360 but that didn't work or I did something wrong
but I now have a formula that works.

Nicole
 
Back
Top