Posted to microsoft.public.excel.programming

JWolf

external usenet poster

Posts: 136

Worksheet_Change Event

Check your spelling more carefully than I did, too.

JWolf wrote:

Use Format, Conditional Format... instead:
Condition 1: formula is: =or(I5="Returned",I5="Corrected & Returned");
set format color 35
click add
Condition 2: formula is: =or(I5="Correctd, Not Yet
Returned",I5="Completed, Not Yet Returned",
I5= "Received, Not Yet Completed",I5= "Violation: See Notes"); set
format color 36
click add
Condtion 3: cell value: = "Not Yet Received"; set format color 3

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disabling WORKSHEET_CHANGE event	Jase	Excel Discussion (Misc queries)	1	April 25th 08 04:32 PM
worksheet_change event with a combo box	ice_cool	Excel Programming	3	February 13th 04 03:11 PM
Problem with Worksheet_Change event	Romuald	Excel Programming	2	January 19th 04 09:41 AM
Worksheet_Change Event	Sam	Excel Programming	2	November 21st 03 06:51 PM
xl97 and Worksheet_Change event ?	Greg Wilson[_3_]	Excel Programming	1	September 10th 03 04:17 AM

All times are GMT +1. The time now is 04:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us