• 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.

Font style specified in formula, for dashboards?

G

greg.begin

Member
Is it possible to specify a font style in a formula, kind of like the Text(1564,###.0) formula but font style? I want to add a webdings character in the answer of my formula.
 
Hi Greg

Unfortunately No

A cell can contain many Font Styles, but they can't be added/changed via formula


What exactly do you want to do ?

There may be other work-arounds
 
the KPI dashboard has an arrow icon, but it only goes one way, i want the icon, for negative values, to go to the right and not just the left. that way it doesn't confuse the user. i have however, conditionally formatted it for green for positive and red for negative, but not satisfied.
 
Greg

If you use a formula like:

=If(A2<0, t, u)

then set the Font to Wing Dings 3


you will get a Left Arrow (t) if A2 < 0 and a Right Arrow (u) if A2 >= 0

You can also use Up arrow (p) and Down Arrow (q)


You can also use Cf to set colors to Green and Red as appropriate


Have you thought about using the CF icons instead ?
 
Hi Greg ,


To add to what Hui has already posted , check out this link :


http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/


Narayan
 
You must log in or register to reply here.
Back
Top