Excel 2003: Changing colours of TWO cells based on value within one cell

[network_engineer]

Hi all,

1. how would I go about changing the format of one cell based on the value in the adjacent cell?

E.g. change the shading or font colour of both C4 and D4, if the value in C4 has changed?

E.g.
if C4 = High, then C4:D4
if C4 = Nominal, then C4:D4
if C4 = Low, then C4:D4

Part II
How do I replicate this to other cells, C5:C65536 and D5:D65536? I tried copy/paste special/format, but it did not work!

Kind regards.
Thanks!

 

[id107]

Select the range you want to format and go to Format>Conditional Formatting, select "Formula Is", then input =$C4="high" and set the format for high, click "add" and repeat for the other two.

The $ tells the conditional format to only look at the value in column C on each row.

 

[network_engineer]

Thanks a lot - appreciate it!