How I do this formula ?

H

HR157

I would like to format all words that said “customer” in a column to
chosen color.Can anyone provide a formula or conditional formattin
that will do
this
 
P

Pete_UK

You could apply an autofilter to the column and select Custom |
Contains then enter customer. This will only display those rows which
contain customer in that column, and you can highlight the cells and
set your format accordingly.

Hope this helps.

Pete
 
P

Pete_UK

Alternatively, if you want to apply conditional formatting, then assume
the cells you want this to apply to are A2 to A50 - highlight this
range, then click Format | Conditional Formatting and in the first box
select "Formula Is" rather than "Cell Value Is", then enter this
formula:

=SEARCH("customer",A2)

Click the Format button and choose your effect - e.g. Red foreground
colour and Bold. Then click OK, and the cells containing "customer"
should now be emboldened in red.

Hope this helps.

Pete
 
R

RagDyeR

Select the column, say Column A, then,
<Format> <ConditionalFormatting>,
First box is "Cell value is",
Second box, choose "Equal to",
Third box, enter "customer" (no quotes),
Click on format, and choose whatever you wish,
Then <OK> <OK>.

NOW, this will *only* format the cell if it contains the *single* word,
"customer".

If you have "customer" in the cell with other words, then try this:
First box, choose "Formula is",
Second box, enter this formula:
=ISNUMBER(SEARCH("customer",A1))
Click on format, and choose whatever you wish,
Then <OK> <OK>.


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


message
I would like to format all words that said “customer” in a column to a
chosen color.Can anyone provide a formula or conditional formatting
that will do
this.
 
Top