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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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,109,454
Messages
5,528,862
Members
409,841
Latest member
Orval_Effertz
Top