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