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?
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks