Temporary formatting???

  • Thread starter Thread starter AXidentProne
  • Start date Start date
A

AXidentProne

Hi
I am using a database in Notes. Now while i realize that lotus is th
devil, and that it is worlds apart from excel, I am better than averag
at excel and often the solutions to problems in excel lead me to th
solutions in lotus.
so this question
I have to update the aforementioned database quite often, and wa
wondering if there is a condition format which is applied to =DATE + 3
(or something to that extent)
IOW, I input the new information, and it stays the formatted color fo
30 days then changes to the default text settings or drops the formul
away entirely
any leads will be greatly appreciate
 
Play around with format|conditional formatting:

"Cell Value is" "less than" =today()+30

I'm not sure if you want less than or +30, but you'll be darn close for your
next experiment.
 
Back
Top