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?