Conditional Format a range based on 1 cell

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

 

[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.