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.
--
Etourneaul 28

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.

--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Etourneaul" wrote:

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.
--
Etourneaul 28

Thank you for your help. Now where do i rate this post?
--
Etourneaul 28


"Etourneaul" wrote:

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.
--
Etourneaul 28