Excel Excel Conditional Format

S

Simont485

Joined
Feb 23, 2018
Messages
67
Reaction score
24
I want to condition format cells that contain uppercase H but not those that contain h (lowercase). There is other text in the cells too.

So cells I want to highlight would contain, for example, H-e or H

but not D-h or h

Many Thanks in advance
 
Select the relevant cells (eg column A) and go to Conditional Formating > New Rule. You want to pick the option to use a formula, and this is the formula you want to use:

=ISNUMBER(FIND($B$1,A1))

Where cell B1 contains what you want to find (eg H), and A1 is the first cell in the column you want to apply the conditional formatting to.

If you will only ever be looking for an uppercase H, you could change $B$1 to "H" if you want, but using a reference to a separate cell allows you to change what you're looking for more easily in the future if you want to.

Hope this helps! :)
 
Yes thank you. Also got an answer on another thread and that works...

So in conditional format formula type:

=if(and(ISNUMBER(FIND("H",A2))=true, ISNUMBER(FIND("h",A2))=false)
and set the format for red text. Then apply it across the range of cells to show the format.

All cells in the range with H in them format with red text and cells with h don't
 
Back
Top