# Highlight a cell in a specific row

Solved/Closed
Related:

- 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

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)))