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
Folder highlight - Download - Customization
Saints row 2 cheats - Guide
An example of a cell is a blank cell ✓ - Programming Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Count if cell contains number - Excel Forum

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

How to use conditional format based on text?

If a cell contains any text then add a value

Ig stories from close friends to public

Highlight cell if another cell contains specific text

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!