Conditional Format a range based on 1 cell
In Excel 2003, is it possible to conditionally format a range based on the
value in one of the cells in that range. for example I have a record with several columns. Can I change the fill color of the entire row for that record based on the value in one of the cells in that range? |
Conditional Format a range based on 1 cell
Yes. Instead of using Cell value is use Formula and create the condition
based on the one cell. Use Absolute referencing to ensure you reference the correct cell. So Formula is =$A110 will always reference the cell in column A of whatever row the format is on. -- HTH... Jim Thomlinson "Rich" wrote: In Excel 2003, is it possible to conditionally format a range based on the value in one of the cells in that range. for example I have a record with several columns. Can I change the fill color of the entire row for that record based on the value in one of the cells in that range? |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com