Checking cells for input

S

Samuel Looney

I have a worksheet that has 107 rows. The number of rows can change as users
add records. The last 3 columns in each row are status's of each record
indicated by one of the cells having an X in it. I want to allow only 1 of
these 3 status cells in each row to contain the value of "X". Any help or
suggestions would be greatly appreciated.
 
B

Bernie Deitrick

Samuel,

Use Data Validation, selecting "Custom" with a formula like

=COUNTIF($H2:$J2,"X")=1

Where H to J are the last three columns of your row.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Excel VBA 1
Take Action on Cells within Selection 3
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Drawing a line for a set range 1
Macro Help with Variable 1
Excel spreadsheet to Word document 1
Excel 2013 Merge Data 2

Top