• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting - Customized icon sets

V

vinwin06

New Member
Hi,


Actually i am looking for an conditional formatting with icon set of "Left and Right arrow" with the colored one like amber. I know that i can get this using windings font but i dont know how to color those arrows. Can you please anyone help me on this.


Thanks in advance.
 
To add to what bobhc said, the icons you want are available in CF formatting in XL 2007+. If you're in 2003, you'll have to use a font (like wingdings) with formulas. Which version is this for?
 
Its for excel 2007 , but there is no icon set available in CF for right and left arrow symbol. Can you please help me how i can get that. Can i able icon like this "<->" in conditional formatting.
 
VinWin06

You can't customise Icon Sets in CF in any excel version yet

I believe this is a serious deficiency in Excel, but who am I


You can however use a Formula to do what you want


you can use a WingDing Font to insert Arrows

ie: Use a Formula like: =If(A1<100,a,b)

now use the Insert character Command

Insert the two characters you want

Copy and paste them into the formula in place of a and b

Change the Font Type of the cell to WingDings
 
Thanks for your reply. But if include the character can i able to get it as fully colored one like we are getting it in CF.


Another question can we able to create conditional formatting like one condition for color and one condition for the shape is it possible in excel 2007?
 
I think you need to be careful of your nomenclature


Cells display Text or Numbers, which are all characters from a Font Type eg: Arial

Some of the Fonts characters may look like shapes, but they are still plain text.


As Text, WingDings 1, 2 & 3 and the WebDings fonts are used exactly the same as a normal formula


In Conditional Formatting you have the option of setting the cells background Color or the Fonts Display Color

You can't mix Font colors in CF, it can only be done manually
 
You must log in or register to reply here.
Back
Top