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
If cell contains specific text then return value in another cell ✓ - Excel Forum
Folder highlight - Download - Customization
Excel conditional formatting if another cell contains specific text - Excel Forum
Count if cell contains number - Excel Forum
Which key is used to make multiple line in a single cell - Guide

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?

Ig stories from close friends to public

Highlight cell if another cell contains specific text

If a cell contains any text then add a value

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!