Prev: Count function not working in one workbook
Next: Average using Sumproduct or ....
From: Rich on 13 Apr 2010 09:59
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?
From: Jim Thomlinson on 13 Apr 2010 10:08
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.
--
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?
 | 
Pages: 1
Prev: Count function not working in one workbook
Next: Average using Sumproduct or ....