Conditional Format a range based on 1 cell

  • Thread starter Thread starter Rich
  • Start date Start date
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?
 
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.
 
Back
Top