Formulate a cell to change color when above/below an amount?

G

Guest

Is it possible to formulate a cell that can change the color when the number
falls above or below a "goal" amount, that is set in the table?

ex.: My goal is to reach 10%, but when the numbers are entered, my total was
only 8%, therefore that cell should be shaded red.

Please help! Thanks!
 
P

Peo Sjoblom

Look in help for conditional formatting

set cell value less than 10%


--


Regards,


Peo Sjoblom
 
P

Peo Sjoblom

Sorry didn't see that you wanted to include above 10% as well so use not
equal to instead

also note that if the percentage is due to a calculation you might thing it
is 10% while instead it might
be something else that your formatting rounds the display to 10%


--


Regards,


Peo Sjoblom
 

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

would like to combine info. fr different location on a list 3
How to change cell background color as part of the If statement? 2
percentage removal problem 0
Color change on bars when goal met 2
Cell Color Recognition and Summing of Data Within a Specified Colo 1
change font color depending on cell value 11
dividing by 0 error 6
Changing cell color with a formula? 3

Top