Conditional Formatting - Wingdings 3 - Change Font and Color

[Sphinx404]

I have no idea how to do this... I'm at my wits end....

I cannot use the icon sets because our corporate data governance maintains that I must use the equivalent of Wingdings 3... letters Q, U, or P... which are all arrows.

The formula I have contained in the cells works just fine, and it works just fine with the icon sets... but I need it to work for these dumb wingding symbols.

Example formula:

=IFERROR(SLOPE(R10:T10,$R$5:$T$5)/ABS(SLOPE(R10:T10,$R$5:$T$5)),0)

So I need to write this formula to say something like:

IF formula is >= 1 then "P" (in wingdings3 font format)
IF formula is >= 0 then "U" (in wingdings3 font format)
IF formula is < 0 then "Q" (in wingdings3 font format)

But this is the part my head can't wrap around...

IF formula is >=1 then color the wingdings font RED
IF formula is >=0 then color the wingdings font YELLOW
IF formula is <0 then color the wingdings font GREEN

I have no idea how to do this in Excel Conditional Formatting

I've tried putting 2, 1, and 0 in cells A1, A2, A3 and running trial conditional formats, but I cannot change the font to wingdings3 or some specific letter to get the arrow I am looking for.

So... How to I write a formula to change the font to wingdings3, and to the letter "P, U or Q" so it displays the corresponding arrows? If I can do that, then I think I might be able to write a condition saying if cell value = P then change font color red, yellow, green, etc.

IDEAS? Anyone? Please help!

 

[rpaulson]

here is the CF I used. I used all 3 on one cell. I did not create a formula for the CF



Cell Value < 0 'green
Cell Value <between 0 and 1 ' yellow
Cell Value > 1 ' red

 

[MHamid]

Hello,

I was actually looking into this same issue I am currently having and I found a youtube video that helped me. Check it out, it might help you out too.

https://www.youtube.com/watch?v=sffJN-u4zE0