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 |
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 |
All times are GMT +1. The time now is 09:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com