|
| 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
May 12th, 2009, 12:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
specific percentage formula
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 
|
|
#2
May 12th, 2009, 06:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
specific percentage formula
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
|
|
#3
May 13th, 2009, 03:21 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
specific percentage formula
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
