Another Conditional formatting problem

[Brian from Maui]

Aloha!

I can't see the trees through the forest. The other day I learned from this board to conditionally format a cell with the =now()-a1>365.25 from a given date, for training purposes. I'd like to take this one step further and prompt the user with green (less than 300 days a year, yellow (more than 301 days) and red for less than week from year.
Getting fustrated!!!!!

Brian
This message was edited by Brian from Maui on 2002-02-24 16:17

 

[Brian from Maui]

Aloha All,

Figured it out.