Conditional formatting

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I'm creating an excel doc and I have used vba to conditional format a cell based on an exact match i.e. "HOL" so that when HOL appears a cell the cell background colour changes to a colour.

My question, is there a way to shade a cell based on a letter in a cell following a word for example if i enter 'example' in to a cell nothing happens but when i enter 'example t' in to a cell the backgound of the cell is shaded. I also want to use other words in place of example so that the letter t defines the rule

Hope this makes sense

Can any one help

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
SUPPOSE column A has entries some example,some example t or some even radio t etc

try this formula for conditional formatting for A1

=AND(ISNUMBER(SEARCH("example",A1)),ISNUMBER(SEARCH("t",A1)))

copy A1 down and pastespecial-format

Remember this will color only example t not radiot