Conditional Formatting Icon Sets

kevinm12

New Member
Joined
Oct 8, 2014
Messages
2
As you will be no doubt aware I am not very good with Conditional Formatting.
I have looked but I can find this answer, I really do apologize if its there.

All I want to do is have a green light appear next to the text in a cell if that cell has any kind of text/number in it.
If the cell has nothing in it then the cell should remain blank, I only want the green light when the cell is populated.
Can anyone give me a quick explanation of how to achieve this please.

Thanks in advance

K
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Leandroarb

Board Regular
Joined
Oct 7, 2014
Messages
155
Hi Kevin, you can do it this way: If you want cell D1 turns green when the cell C1 has something inside it, select cell D1 and type in conditional formatting formula: =C1<>"" and set the color of background as green.
 

kevinm12

New Member
Joined
Oct 8, 2014
Messages
2
yes that's kind of it but I want the traffic light icon to appear in the cell as opposed to the cell turning green.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,942
Messages
5,545,114
Members
410,660
Latest member
marciabkin
Top