Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-24-2013, 12:05 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting Tick Icons Windows 7 64bit Conditional Formatting Tick Icons Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM
Conditional Formatting Tick Icons Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional Formatting Tick Icons Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM
Conditional Formatting Tick Icons help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft