Excel - conditional formatting issue

R

Raj

Hai,
I have an issue in Excel 2003 wherein i am not able to highlight cells that
contains a particular word, checkout the example below, im looking forward to
highlight cells which has "vip"
I am able to do the same in Excel 2007.

lnaipsa01.ln.fw.gs.com
lnampla10.ln.gsam.gs.com
lnccpla02.ln.fw.gs.com
lnclpla01-vip.ln.fw.gs.com
lnclpla01-vip.ln.fw.gs.com
lnclpla02-vip.ln.fw.gs.com
 
P

Pete_UK

You do not explain how you have done this in Excel 2007, but in Excel
2003 highlight the data that you want this to apply to (A1:A6 in your
example), then click on Format | Conditional Formatting and choose
Formula Is rather than Cell Value Is in the first box. In the formula
box enter:

=ISNUMBER(SEARCH("vip",A1))

Then click on the Format button, Patterns tab and choose your colour.
OK your way out of the dialogue box, and you should see three of the
cells highlighted.

Hope this helps.

Pete
 
P

Pungigi

Can you do this where if it's VIP make red else if its ABC make green????


Thanks


Lisa
 
P

Pete_UK

This has two conditions, so you set the first one up as shown above,
but once you have set this and click OK once (to get back to the
dialogue box) then you click Add and set up a second condition in a
similar way, but using ABC instead of VIP and choosing Green.

Hope this helps.

Pete
 
Top