If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
changing color if value exceed speficied amount
What would the formula be so that if a vaule is exceeded
it would change the color of the value. lets say if the vaule is 75% or greater you would want the color of this valus to change to "red" Thanks for any help |
#2
|
|||
|
|||
changing color if value exceed speficied amount
Hi
have a look at 'Format - Conditionla Format' for this -- Regards Frank Kabel Frankfurt, Germany wrote: What would the formula be so that if a vaule is exceeded it would change the color of the value. lets say if the vaule is 75% or greater you would want the color of this valus to change to "red" Thanks for any help |
#3
|
|||
|
|||
changing color if value exceed speficied amount
Hi
Go to Format / Conditional Formatting. Select Formula is in the first box and type =A2110*0.75 (if your cell is A2 and the value is 75% of 110) You can then set the format as you wish -- Andy. wrote in message ... What would the formula be so that if a vaule is exceeded it would change the color of the value. lets say if the vaule is 75% or greater you would want the color of this valus to change to "red" Thanks for any help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to reduce amount when another amount is entered | johnathon | Worksheet Functions | 1 | November 7th, 2003 11:47 AM |