ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stoplight symbols in cells (https://www.excelbanter.com/excel-discussion-misc-queries/112066-stoplight-symbols-cells.html)

wacNTN

Stoplight symbols in cells
 
I want to use red, yellow and green circles in a cell instead of the words
red, yellow, green. Is there a way to do this?

Thanks,

Walter
--
WAC

Bob Phillips

Stoplight symbols in cells
 
http://xldynamic.com/source/xld.CF.html#lights

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wacNTN" wrote in message
...
I want to use red, yellow and green circles in a cell instead of the words
red, yellow, green. Is there a way to do this?

Thanks,

Walter
--
WAC




MyVeryOwnSelf

Stoplight symbols in cells
 
I want to use red, yellow and green circles in a cell instead of the
words red, yellow, green. Is there a way to do this?


One way is to type lower case n into a cell, change it to Webdings font,
then use
Format Cells Font
and change the color.


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com