Another Conditional formatting problem

Brian from Maui · Feb 24th, 2002, 05:16 PM

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 · Feb 24th, 2002, 06:56 PM

Aloha All,

Figured it out.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 24th, 2002, 05:16 PM	#1
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	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 ]

Feb 24th, 2002, 06:56 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Aloha All, Figured it out.