Highlight a cell in a specific row

Solved/Closed
SL - Jul 16, 2010 at 01:58 PM
 SL - Jul 21, 2010 at 05:43 PM
Hello,

I would like to know if anyone knows how to write a Visual Basic script that I could run that will highlight the cell(s) in a color if they do not have have four capital alpha and four numeric. Basically all cells in that row should be CFSF7464.

Please help :)


2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 16, 2010 at 06:36 PM
If the cell would be in this format

<text><text><text><text><number><number><number><number>


you can use conditional format using this formula


=AND(LEN(A1)=8,EXACT(LEFT(A1,4),UPPER(LEFT(A1,4))),NOT(ISERROR(MID(A1,5,4) *1)))
0
Thank you this worked perfectly!
0