Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? -- ANDYPAND ------------------------------------------------------------------------ ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351 View this thread: http://www.excelforum.com/showthread...hreadid=389321 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |