changing color if value exceed speficied amount

G

Guest

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
 
A

Andy B

Hi

Go to Format / Conditional Formatting.
Select Formula is in the first box and type =A2>110*0.75
(if your cell is A2 and the value is 75% of 110)
You can then set the format as you wish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change cell background color as part of the If statement? 2
Not sure what function to use? 3
shading a cell or group of cells based on value 5
Background Color for selected range 7
Changing Cell Color Based on Value 2
How to Color a Cell Based on a Range of Cells with Colors 1
have an entire row populate with a link when the data in a cell ch 1
Changing cell colors from a function command 3

Top