Conditional Formatting
Hello, I am trying to get an entire row's background colour to change in Excel based on the value of one cell in its column. I can get this to work for one cell at a time by using conditional formatting. Is there way to get this to work for multiple cells and rows, whether with or without conditional formatting? Cheers Bronek -- bronek ------------------------------------------------------------------------ bronek's Profile: http://www.excelforum.com/member.php...o&userid=27016 View this thread: http://www.excelforum.com/showthread...hreadid=436209 |
Use an absolute reference by placing dollar signs around the cell reference.
i.e. $A$2. -- Regards, Dave "bronek" wrote: Hello, I am trying to get an entire row's background colour to change in Excel based on the value of one cell in its column. I can get this to work for one cell at a time by using conditional formatting. Is there way to get this to work for multiple cells and rows, whether with or without conditional formatting? Cheers Bronek -- bronek ------------------------------------------------------------------------ bronek's Profile: http://www.excelforum.com/member.php...o&userid=27016 View this thread: http://www.excelforum.com/showthread...hreadid=436209 |
All times are GMT +1. The time now is 02:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com