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 do i find a specific video on youtube - Guide
How to delete a row in a table in word - Guide
Saints row 2 cheats - Guide
How to search for a specific word on a webpage - Guide
The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - 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

Ig stories from close friends to public

Clear cell contents based on value of another cell range using VBA

help me to add particular cells

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!