How to make a lightbulb switch on and off in excel

Рет қаралды 4,059

4 жыл бұрын

The Segoe UI Symbol font has a lightbulb symbol and I used conditional formatting to change its color. I also used a picture of a lightbulb and a scatter chart to make a lightbulb switch on and off.
The lightbulb picture:
www.vectorstock.com/royalty-f...
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelcharts
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 2007
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make a lightbulb turning on animation in powerpoint • How to make a lightbul...
- How to make a traffic light chart in excel • How to make a traffic ...
- Roll of the dice in excel • Roll of the dice in excel

Пікірлер: 8

@charlie9009 5 ай бұрын

Thank you! There's more useful information in this one video than I typically find in a week! I also appreciate your style. I'm an instant subscriber!

@alexclark2576 4 жыл бұрын

Your channel is such a gem. All the content is stuff you can't find anywhere!

@Phenom5 4 жыл бұрын

Jesus christ, your Channel is a goldmine, thank you !

@AmitRoy-om3tp 3 жыл бұрын

Fantastic!

@Phenom5 4 жыл бұрын

Would it be possible to "convert" these images to a value that I can enter in a box? What I mean by that is that I'd like to create a list, where I can select either one of these turned on or off lightbulbs (or whatever image i'm pasting in excel) instead of selecting a string (text) in it. I know I can do it with already existing characters in the already shown Segoe UI Symbol font, but i'd like to import my own set of images. Let me know if that's not clear enough 😁

@karinaadcock 4 жыл бұрын

The closest thing I can think of is: How to make a lookup for pictures in excel kzfaq.info/get/bejne/qreInpSDuNm0dKs.html But thats not really what you want. You might want to try social.msdn.microsoft.com/Forums/office/en-US/20ce9414-fcad-4545-90e3-042dda7c11a2/how-do-i-create-a-excel-drop-down-list-with-a-list-of-imagespictures But I couldn't get this to work.

@karinaadcock 4 жыл бұрын

I also found some other youtube videos about this: kzfaq.info/get/bejne/i7iUjJaQ05qspnk.html kzfaq.info/get/bejne/r5-ejcJj0-CveY0.html

@Phenom5 4 жыл бұрын

@@karinaadcock Thank you so much !! I'll have a look !