Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format rage based on entries within range | Excel Worksheet Functions | |||
Conditional Format for one cell based on range | Excel Worksheet Functions | |||
How to conditional format columns in a range based on | Excel Worksheet Functions | |||
Conditional format a cell based on another range of cells | Excel Worksheet Functions | |||
Conditional Format based on range | Excel Discussion (Misc queries) |