Highlight a cell in a specific row
Solved/Closed
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 :)
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 :)
Related:
- 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
- Why can't i see a person's highlights on instagram - Instagram Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 16, 2010 at 06:36 PM
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)))
<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)))