Conditional Format a range based on 1 cell

R

Rich

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?
 
J

Jim Thomlinson

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 =$A1>10

will always reference the cell in column A of whatever row the format is on.
 
Top