Can I check that entries satisfy a particular format?

**perfection** · 10-17-2010, 12:08 AM

Is there a way that i can check that all entries in a particular column satisfy a certain format and perhaps conditionally format those that do not?

example i wish to check that all entries are exactly in the format xx:yy:zz no more no less!

**WinteE** · 10-17-2010, 04:38 AM

Copy this code into the object of the sheet :

Please Login or Register  to view this content.

You only have to change the range in the 'Intersect' part.

Success,
Erik

**perfection** · 10-17-2010, 04:47 AM

SORRY, I do not understand how to copy into the object of the sheet

I for example need to find all entries that satisfy the format
#:##:##:##
where # is a digit number

Could you be more detailed?

**perfection** · 10-17-2010, 11:54 PM

any more help on this?

**ron2k_1** · 10-18-2010, 12:09 AM

Originally Posted by perfection

SORRY, I do not understand how to copy into the object of the sheet

I for example need to find all entries that satisfy the format
#:##:##:##
where # is a digit number

Could you be more detailed?

Right click on the sheet tab your data is on and select "View Code" and post the code provided there.

WinteE stated that your data in on column A starting from row 1 to row 10, you would have to change this to your actual range.

Ron

**DonkeyOte** · 10-18-2010, 02:57 AM

Originally Posted by perfection

...i wish to check that all entries are exactly in the format xx:yy:zz

Originally Posted by perfection

I for example need to find all entries that satisfy the format
#:##:##:##
where # is a digit number

It would be a good idea to post a sample I think and outline the desired results.

I suspect you will be able to avoid the need for VBA but the approach you apply will depend heavily on the values you're trying to highlight - which at present (given above) is not clear.