hlookup or conditional format?

[EARTHWALKER]

Firstly I must scream AAARRRRGGGHHH!!!
Ah, that's better.

Right, I want the colour of a cell (well lots really). I want it to
change when a different cells value = 2


SO imagine this if you will

A1 white D1=0
A2 white D1=1
A3 white D1=1
A4 white D1=0

If the D cell values change, that's when I want the colours in the A
cells to change:-

A1 white D1=0
A2 Red D1=2
A3 white D1=1
A4 Red D1=2

I think I've explained it well enough.
I think a conditional format would be the easiest way, but can I get it
to work arrgghh!

Many thanks for any help.

 

[Guest]

Hi- select A1
- goto the conditional format dialog
- enter a formula such as
=D1=0
- chhose your format
Repeat for the other conditions and cells

 

[Bob Phillips]

Use CF with a formula of =$D$1=2 and set the pattern colour to Red

--

HTH

RP
(remove nothere from the email address if mailing direct)