Conditional Formatting

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?

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 Format>Conditional 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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>