http://chandoo.org/forums/topic/font-style-specified-in-formula-for-dashboards Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Wed, 19 Jun 2013 06:28:44 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/font-style-specified-in-formula-for-dashboards#post-24741 Wed, 02 May 2012 15:44:02 +0000 Greg 24741@http://chandoo.org/forums/ <p>Great, thanks everyone for your input. </p> http://chandoo.org/forums/topic/font-style-specified-in-formula-for-dashboards#post-24739 Wed, 02 May 2012 15:24:56 +0000 NARAYANK991 24739@http://chandoo.org/forums/ <p>Hi Greg ,</p> <p>To add to what Hui has already posted , check out this link :</p> <p><a href="http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/" rel="nofollow">http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/</a></p> <p>Narayan </p> http://chandoo.org/forums/topic/font-style-specified-in-formula-for-dashboards#post-24738 Wed, 02 May 2012 15:19:35 +0000 Hui 24738@http://chandoo.org/forums/ <p>Greg<br /> If you use a formula like:<br /> =If(A2&lt;0, t, u)<br /> then set the Font to Wing Dings 3</p> <p>you will get a Left Arrow (t) if A2 &lt; 0 and a Right Arrow (u) if A2 &gt;= 0<br /> You can also use Up arrow (p) and Down Arrow (q)</p> <p>You can also use Cf to set colors to Green and Red as appropriate</p> <p>Have you thought about using the CF icons instead ? </p> http://chandoo.org/forums/topic/font-style-specified-in-formula-for-dashboards#post-24737 Wed, 02 May 2012 15:10:55 +0000 Greg 24737@http://chandoo.org/forums/ <p>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. </p> http://chandoo.org/forums/topic/font-style-specified-in-formula-for-dashboards#post-24734 Wed, 02 May 2012 15:07:16 +0000 Hui 24734@http://chandoo.org/forums/ <p>Hi Greg<br /> Unfortunately No<br /> A cell can contain many Font Styles, but they can't be added/changed via formula</p> <p>What exactly do you want to do ?<br /> There may be other work-arounds </p> http://chandoo.org/forums/topic/font-style-specified-in-formula-for-dashboards#post-24732 Wed, 02 May 2012 15:04:29 +0000 Greg 24732@http://chandoo.org/forums/ <p>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. </p>