Conditional Formatting

[ANDYPAND]

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?

 

[KL]

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