View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default change a display every 60 days in a cell in excel

Assuming it can be done, how will you flag the users?

You may have the top row shown in Red on the 1st of every even month...
using conditional formatting and =today() formula in A1

"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