Highlight a cell in a specific row
Solved/Closed
Related:
- Highlight a cell in a specific row
- How to search for a specific word on a webpage - Guide
- How do i find a specific video on youtube - Guide
- Saints row 2 cheats - Guide
- How to delete a row in a table in word - Guide
- Instagram highlight not loading - 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)))
