Custom Image to Conditional Formatting

[jbartholomew]

I have been asked to add a custom image (a thumbs up) to each cell that has a higher number than the previous one. I already have conditional formatting to shade this cell blue. I can add the standard red, yellow, green lights or arrows, but need help for the custom picture!

 

[oldbrewer]

has dingbats got a suitable character ?

 

[jbartholomew]

Like the font Wingdings?

 

[oldbrewer]

[TABLE="width: 256"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]A1 = char(67)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]font is windings[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]this shows a C but believe me it is a thumbs up[/TD]
[/TR]
</tbody>[/TABLE]

 

[jbartholomew]

How do I write this into a formula?

 

[DRSteele]

Much to my surprise - YES, you can do it. The character for thumbs-up is in Symbols character set Windings; the function CHAR(67) reports that very symbol. To test it out, put CHAR(67) in any cell and format the cell with font Wingdings and size, I dunno, 24 and you'll get a thumbs-up. here is an example using random numbers. Notice that what you see on this page is just a "C", but in Excel it will be a thumbs-up. Also notice that you can't put the symbol as an icon-set in the cell like you can for Conditional Formatting but it's probably good enough that you can put it beside your data and frame it with a border. You can also read this source: http://blog.contextures.com/archives/2013/09/03/create-your-own-excel-icon-set/

Excel 2012
	A	B	C
1		C
2
3		data	greater than previous?
4		1
5		5	C
6		19	C
7		25	C
8		3
9		9	C
10		14	C
11		7
12		5
13		25	C
14		24
15		14
16
Sheet23

Cell Formulas
Range	Formula
B1	=CHAR(67)
B4	=RANDBETWEEN(1,25)
B5	=RANDBETWEEN(1,25)
B6	=RANDBETWEEN(1,25)
B7	=RANDBETWEEN(1,25)
B8	=RANDBETWEEN(1,25)
B9	=RANDBETWEEN(1,25)
B10	=RANDBETWEEN(1,25)
B11	=RANDBETWEEN(1,25)
B12	=RANDBETWEEN(1,25)
B13	=RANDBETWEEN(1,25)
B14	=RANDBETWEEN(1,25)
B15	=RANDBETWEEN(1,25)
C5	=IF(B5>B4,CHAR(67),"")
C6	=IF(B6>B5,CHAR(67),"")
C7	=IF(B7>B6,CHAR(67),"")
C8	=IF(B8>B7,CHAR(67),"")
C9	=IF(B9>B8,CHAR(67),"")
C10	=IF(B10>B9,CHAR(67),"")
C11	=IF(B11>B10,CHAR(67),"")
C12	=IF(B12>B11,CHAR(67),"")
C13	=IF(B13>B12,CHAR(67),"")
C14	=IF(B14>B13,CHAR(67),"")
C15	=IF(B15>B14,CHAR(67),"")