Conditional Formatting with Text Values

**mikello** · 08-06-2009, 08:04 AM

Dear All,
I'm having a workbook with plenty of words on c' columns.
BR-123,BR-124,BR-125 like this,just i need to give a conditional
format based on it should be of same space.

Eg:BR-123 & BR-124 are similar ,but it cannot be Br-125 or BR - 126.

Please advise,

Thanks in Advance,
Mike

**NBVC** · 08-06-2009, 08:44 AM

Please post a workbook sample of the possibilties and what you expect as a result of the conditional formatting.

**mikello** · 08-06-2009, 08:51 AM

Please find the attached.

Thanks ,
Mike

**NBVC** · 08-06-2009, 09:04 AM

Select A1:A9 and go to Format|Conditional Formatting

Select Formula Is from 1st drop down and enter formula:

=AND(EXACT(A1,UPPER(A1)),ISERROR(FIND(" ",A1)))

then click Format and choose from Pattern tab.