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

If a cell contains any text then add a value

Highlight cell if another cell contains specific text

help me to add particular cells

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

Similar discussions

Subscribe To Our Newsletter!