Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format of one cell conditional on another | Excel Worksheet Functions | |||
Reference Cell in custom format???? | Excel Discussion (Misc queries) | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |