specific percentage formula

E

Etourneaul

I'm looking for a way to create a formula that shows that if any percentage
over 10% shows up red. Any other results below 10% stay black. Currently i
have a sheet that does this but for some reason in the format box it only
shows percentage with no special instructions. I then looked into the custom
and found no formula but that sheet that i have is doing it for some reason
and i want to understand it.
 
M

Martin Fishlock

Hello:

Try using Conditional Formatting, from the Home tab (2007) or from the
format menu in previous versions.

Set the condition >0.1 and set the format to the required format.
 

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

Notes not showing up in Powerpoint Presenter Mode 0
percentage in brackets 2
Weighted % Complete calculation 1
difference in numbers displayed as a +/- percentage 3
Percentages 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
Show a cell's formula in text format in a linked cell 2
Assigning a set value to a cell that has a percentage? 4

Top