Posted to microsoft.public.excel.worksheet.functions

evoxfan

external usenet poster

Posts: 65

Conditional Data Validation

I have a column (D) to enter a dollar amount of a transaction. All
transactions are classifed in column A as either cost or revenue. I want to
make sure that cells classified as cost in column A have a negative value and
cells classified as revenue in column A have a positive value.

Any help is appreciated.

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
Conditional Data Validation	Xanoca	Excel Discussion (Misc queries)	1	June 15th 08 02:23 PM
Conditional Data Validation	Walt Herman	Excel Worksheet Functions	5	October 31st 07 08:58 PM
Conditional data validation.	Dolphy	Excel Discussion (Misc queries)	3	October 9th 07 05:04 AM
Conditional Data Validation	Peter1999	Excel Discussion (Misc queries)	3	May 3rd 06 03:54 PM
conditional data validation	RickS	Excel Worksheet Functions	6	December 16th 05 01:11 PM

All times are GMT +1. The time now is 02:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us