Hi Andy,

You are right. If you format the range [A2:A10] then:

1) select the range [A2:A10] (make sure [A2] remains active)
2) go to menu FormatConditional Formatting
3) In condition 1 choose 'Formula is' from the 1st dropdown
4) put the following formula into the formula box: =B2=5
5) presss the Format button and select your prefered formats
6) press OK,OK
7) try entering 5 into any cell in the range [B2:B10]

Regards,
KL


"ANDYPAND" wrote in
message ...

I am trying to apply a condional format to a range of cells in a
column.
I want the cells to turn green when a cell in an adjacent column = 5.
Presumably this can be done by a formula in conditional formatting?
Can anyone adsvise?


--
ANDYPAND
------------------------------------------------------------------------
ANDYPAND's Profile:
http://www.excelforum.com/member.php...o&userid=25351
View this thread: http://www.excelforum.com/showthread...hreadid=389321