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

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

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

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

"LabrGuy Bob R" wrote in message
...
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

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

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

for an overview of events.

--
Regards,
Tom Ogilvy


"LabrGuy Bob R" wrote:

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

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

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

BOB

"Tom Ogilvy" wrote in message
...
Since your in programming, use the Change Event
http://www.cpearson.com/excel/events.htm

for an overview of events.

--
Regards,
Tom Ogilvy


"LabrGuy Bob R" wrote:

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