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 :)

Highlight a cell in a specific row
How to find specific words on a page - Guide
How to delete a row in a table in word - Guide
Saints row 2 cheats - Guide
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Folder highlight - Download - Customization

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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)))

Answer 2 / 2

SL
Jul 21, 2010 at 05:43 PM

Thank you this worked perfectly!

Similar discussions

Ig stories from close friends to public

help me to add particular cells

If a cell contains any text then add a value

Highlight cell if another cell contains specific text

If cell A1 has text then cell B2 has today's Date

Similar discussions

Subscribe To Our Newsletter!