Posted to microsoft.public.excel.misc

Teddy-B

external usenet poster

Posts: 76

Validation Formula

Hi everyone. I need a validation formula that will allow (only) the word
"CHIPS" in the validation cell if cell A1<"MB". If Cell A1="MB", then the
words "CASH, CHIPS, or CHECK" (only) may be entered.

Please help- "Thanks"

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
data validation with a formula	LabrGuy Bob R	Excel Worksheet Functions	7	July 2nd 07 11:04 PM
Validation Formula	Teddy-B	Excel Discussion (Misc queries)	3	December 28th 06 08:19 PM
Validation Formula	cathyds1	Excel Discussion (Misc queries)	5	November 28th 06 06:54 PM
formula using data validation	Tuttamay77	Excel Discussion (Misc queries)	5	April 4th 06 10:44 AM
need cell validation formula help	adear11	Excel Discussion (Misc queries)	0	November 9th 05 05:01 PM

All times are GMT +1. The time now is 11:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us