![]() |
|
#1
|
|||
|
|||
![]()
Can someone help me? I am trying to use Conditional Formatting to highlight certain figures with icons. I would like any percentage greater than 1% to show a Green up arrow. Any percentage that is 0% to show a straight yellow arrow and any percentage less than -1 to be red.
Can anyone help me out please I just can’t seem to get it to work? Cheers |
#2
|
||||
|
||||
![]()
I only just graduated to Excel 2010, myself, Brad, so I've never actually used the icons in conditional formatting. But someone pointed them out to me a few months ago, and I at least tested them and found that they work. You say you can't get it to work, but how? I mean, what (exactly) are you doing, and how does Excel respond?
|
#3
|
||||
|
||||
![]()
Here goes
Select the range to format Conditional Formatting New rules Format Style Select: Icon sets Icon style : select the set you want In the first Value ddown box enter 0.01 and change the type to "Number" In the second value ddown enter -0.01 and change the type in the same way OK Format your cell as percentage enter your value, the icon should be as requested ( first time I use these icon sets, quite easy as you can see)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
![]() |
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
![]() |
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |