Is it possible to put two different validations into one Cell or a workaround

[LabrGuy Bob R]

Hello,
I am using XP and Office 2003. I have a row of cells, lets say 26 columns.
1. All are conditionaly formatted to change colors as appropriate
2. 10 of them have a validation list so that the user is offered a pulldown
choice of one selection.
3. There is one column that is titled "Total" and it calculates countA for
cells G through P.

So I have
A-F has no validation on any of the cells
G-P has a list validation in each cell
Q is a formula and calculated field.
R-Z has no validation on any of the cells

A-Z has conditional formatting for the entire row.

Rows may only contain one entry in cells G-P

If there is more than one entry in cells G-P, as evidenced by cell Q1
counting over the number 1, I would like to have a message box appear
advising that "Columns G through P have more than one entry, Please
Correct!!!.

I can't get dual validation to work, so I was wondering if someone could
duplicate this and help.
Thanks
Bob Reynolds

 

[LabrGuy Bob R]

I've solved the issue, thanks but assistance isn't needed anymore.
Bob

 

[Tom Ogilvy]

Since your in programming, use the Change Event
http://www.cpearson.com/excel/events.htm

for an overview of events.

 

[LabrGuy Bob R]

Thanks Tom, That piece of info will be very helpful while I'm trying to
learn.

BOB