Excel Excel Conditional Format


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
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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! :)
 
Ad

Advertisements

Joined
Feb 23, 2018
Messages
67
Reaction score
24
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top