Need some help with validation.

[binaryfx]

If a checkbox is checked I need to ensure that at least one cell in a range of cells contains a 6 digit number, It may contain more numbers and even dashes but it must contain 6 digits. I am stumped on this one.

I have a cell linked to the check box.

I have also created a formula that counts the number of characters in the range of cells. I thought I could use custom validation and use those two variables to determine if it was validated, but I have been unable to come up with anything that works.

Thanks in advance for any help you can provide.

-Mike

[bebo021999]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[binaryfx]

No dice. I have tried three different browsers on two different OSs and it will not let me upload the file.

Let me try to explain it a little better...

I have three cells which are for different tax id numbers for the purpose of proving tax free status.
I only need one of those cells to be completed if a checkbox(checkbox is linked to cell I59) is checked.

The entry will be a 6 digit number but could include dashes so it might go up to 12 digits. i am not concerened with the format, only that something is entered and is at least 6 digits in length.

What I was thinking about was a nested IF

something like:

=IF(I59=TRUE,IF("count of digits in the nameed range of cells which is called TAXID" >= 6,continue,ERROR),proceed)

The part in quotes is what I am unable to work out. Does that make it about as clear as mud?