Hi,

We really need more detail, like 60 days from when, how long do you want the
change to apply.

However, suppose you want a cell or cells to change color every 60 days for
that one day, here is a cute formula to get you started:

1. Select the cell(s) you want to change color (you could select the entire
sheet)
2. Choose Format, Conditional Formatting, from the first drop down pick
Formula is, and in the next box enter the formula

=MOD(TODAY(),60)=0

3. Click the Format button and on the Patterns tab pick a color and then
click OK twice.
Once every 60 days the selected cell(s) will change color for one day. It
will always be the same color, but you can get a little fancier in 2003 and a
lot fancier in 2007.

If this helps please click the Yes button.
--
Thanks,
Shane Devenshire


"Paul" wrote:

How can I setup a cell so that every 60 days it will change a display to
something different. I am setting up a follow up tracking system for clients
and because I can only get a list from the database that is imported to excel
I wanted to set up a formula that will flag people every 60 days. Can anyone
help. Thank you

Paul