Previous Topic Next Topic

Conditional formatting

Closed
Gords - Feb 2, 2012 at 03:59 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 3, 2012 at 12:04 AM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 3, 2012 at 12:04 AM
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
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses