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
cell M10 if K10<"MB". If K10="MB" then allow (only) the words "Cash",
"Check" or "Chips".

Thanks for your help!

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
Validation Formula	Teddy-B	Excel Discussion (Misc queries)	7	January 23rd 08 08:53 PM
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
data validation formula	Kimberly	Excel Discussion (Misc queries)	4	November 12th 06 03:01 PM

All times are GMT +1. The time now is 01:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us