This works as long as you only want a total of 4 different colours (1 base
and 3 defined by conditional formatting).

Kate if you want to have both "cds" and "vgh" turning blue, use
Formula is =OR(A1="cds",A1="vgh")

rather than cell value is

HTH please rate
--
Allllen


"shail" wrote:

Hi Kate,

Do the following:

1. Go to Formats/Conditional Formatting
2. "Cell Value Is" selected, select drop down box next to it as "Equal
To"
3. Next box type as "cds"
4. Click Format button
5. Choose the thing you want to as - if you want the font to be
coloured or background to be coloured. Select.
6. For next word "vgh", click at "Add" button.
7. Repeat steps 2 to 5

After completing your steps click OK to finish. Then Copy the cell
where you have done the conditional Formatting. Select the data range.
Right click your mouse button, select paste special/Formats.

Hope this will help you.

Thanks,

Shail

kate wrote:
Could you please help me?
I am trying to format text to highlight different colours depending on code
e.g

cds (I would like to be blue) and vgh ( I would like to be blue)
bn (I would like to be red)
cda ( I would like to be orange) and khg (I would like to be orange)

and so on...
The data range is c1:c550 with various names
hope you can help thankyou Kate