Dashboard with Lights

[Daylon]

Hello,

I'm trying to create a professional looking Dashboard that a person can look at and know if everything on the document has been filled out. I was thinking of using the stoplight feature, but I cannot figure out how to make it look for words instead.

An example would be that on sheet 1, cells C3, C4, C5, C15, H18, H31 etc. must be filled in with non specific text before this dashboard will have all green lights.

I hope that helps visualize what I'm trying to accomplish.

Thank you for the help.

 

[awoohaw]

I could not get icon sets to work with text. But this highlights cells that are good and not complete.
You could probably put some kind of "AND" criteria in as well to only highlight the red ones after at least one sell is populated or something like that.

Mr Excel Questions 73.xlsm
	C	D
1
2	gfd
3	fgsdfg
4	fsg
5
6	fgsf
7
8	fgsf
9
10	fgs
11
Daylon

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:C10	Expression	=C2=""	text	NO
C2:C10	Expression	=C2<>""	text	NO

 

[Daylon]

Yeah, I was able to have the cell highlight. But I was just wanting to see if I could find more of a dashboard type feel to things.

No big deal though.

 

[Jeffrey Mahoney]

Please Try This:

Cell B1 is actually a Wingdings font with a Big Circle like a stop light. Cell A1 has been number formatted as ;;; so that it doesn't show text. Ignore the Icon set conditional formatting

Book1
	A	B	C	D	E	F	G	H
1		l
2
3			Jeff
4			Jason
5			Jan
6
7
8
9
10
11
12
13
14
15			Jane
16
17
18								Jack
19
20
21
22
23
24
25
26
27
28
29
30
31								Joel
Sheet1

Cell Formulas
Range	Formula
A1	A1	=AND(C3<>"",C4<>"",C5<>"",C15<>"",H18<>"",H31<>"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	Expression	=$A$1=TRUE	text	NO
A1	Other Type	Icon set		NO

 

[awoohaw]

I got it to work with a helper column:

Mr Excel Questions 73.xlsm
	C	D	E
1
2	gfd
3	fgsdfg
4	fsg
5
6	fgsf
7
8	fgsf
9
10	fgs
11
Daylon

Cell Formulas
Range	Formula
D2:D10	D2	=--((C2:C10)<>"")
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D10	Other Type	Icon set		NO

 

[Daylon]

Thanks Jeffery for the help this appears to be cleaner. Also thank you Awoohaww, your solution helped point me in a direction for thinking through the problem.