conditional cell format
 

Can I set some aspect of the cell format based on a formula value?

For example, I would like to change the cell fill color based on whether the
value in that cell is greater than or less than a value in another cell.

--
Gary King

Take a look at Format|conditional formatting

Gary King wrote:

Can I set some aspect of the cell format based on a formula value?

For example, I would like to change the cell fill color based on whether the
value in that cell is greater than or less than a value in another cell.

--
Gary King

--

Dave Peterson

Suppose we are testing A1 against B1

Select A1
Menu FormatConditional Formatting
Change Condition 1 To Formula Is
Add a formula of =$A$1 $B$1
Click Format
Select Pattern
Choose a colour
OK
Click Add Condition
Change Condition 2 To Formula Is
Add a formula of =$A$1< $B$1
Click Format
Select Pattern
Choose a colour
OK
OK

--
HTH

Bob Phillips

"Gary King" wrote in message
...
Can I set some aspect of the cell format based on a formula value?

For example, I would like to change the cell fill color based on whether
the
value in that cell is greater than or less than a value in another cell.

--
Gary King