View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 661
Default change a display every 60 days in a cell in excel

good morning...I was thinking i could use the conditional formatting to flag
the cell from day 50 to 60...then return to normal...the 60 day count would
start from which ever day the client entered the program. I really
appreciate your assistance.

"Sheeloo" wrote:

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