Conditional formating more that 3 cells

[Pencil]

In need help. The conditional formatting I want goes in cells A1 to A10 and
also M1 to M10.

The conditions in cell A1 is:
If the text in cell D1 is "ant" the cell color in A1 should be Yellow
If the text in cell D1 is "noa" the cell color in A1 should be Pale Blue
If the text in cell D1 is "nop" the cell color in A1 should be Tan
If the text in cell D1 is "vac" the cell color in A1 should be Pink
If the text in cell D1 is "req" the cell color in A1 should be Bright Green
If the text in cell D1 is "off" the color in A1 should be Plum

The conditional formatting goes in cells A1 to A10 and M1 to M10 with each
line refering to the cell on the same line in column D, i.e., A6 looks at
D6. M4 looks at P4.

How do I do this?

[Pencil]

Pencil <[email protected]> wrote in
news:[email protected]:

> The conditional formatting goes in cells A1 to A10 and M1 to M10 with
> each line refering to the cell on the same line in column D, i.e., A6
> looks at D6. M4 looks at P4.

The conditional formatting goes in cells A1 to A10 and M1 to M10 with each
line refering to the cell on the same line in column D or P, i.e., A6 looks
at D6. M4 looks at P4.

I think this is cleared.

[Mallycat]

I have provided a solution to this problem previously at this thread http://www.excelforum.com/showthread.php?t=552864

Matt