conditional cell format

G

Gary King

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

Dave Peterson

Take a look at Format|conditional formatting

Gary said:
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.
Click to expand...
 
B

Bob Phillips

Suppose we are testing A1 against B1

Select A1
Menu Format>Conditional 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
 
Top