CF Icon Sets Based on values contained in a row

[MasterK]

Excel 2013
Windows 7 64

Good Afternoon. I'm trying to use an Icon set of the Green, Yellow, Red type that returns a Green "check mark" if the row A1:F1 containers no errors. Something like the below. The values in "Term QTY" and "Term Size" are populated by an Index/Match formula based on values in Column A against another sheet in same workbook.

="NOT(ISERROR($A$8$:$F$8)"

But, it did not work. And then of course a Red "X" if there are errors. I'm having no luck. FYI the column with X's in it is just a separator that's colored solid black in my sheet to help keep data distinguishable. Appreciate any help!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Boking[/TD]
[TD]QTY[/TD]
[TD]Size[/TD]
[TD]x
[/TD]
[TD]Term Qty[/TD]
[TD]Term Size[/TD]
[TD="align: center"]CF Icon Set[/TD]
[/TR]
[TR]
[TD]ABC123456[/TD]
[TD]5[/TD]
[TD]20ST[/TD]
[TD]x[/TD]
[TD]5[/TD]
[TD]20ST[/TD]
[TD]Insert check here[/TD]
[/TR]
[TR]
[TD]ABC654321[/TD]
[TD]3[/TD]
[TD]40HC[/TD]
[TD]x[/TD]
[TD]BKG not Found[/TD]
[TD]#N/A[/TD]
[TD]Insert red X here[/TD]
[/TR]
[TR]
[TD]DEF123456[/TD]
[TD]10[/TD]
[TD]40HC[/TD]
[TD]x[/TD]
[TD]10[/TD]
[TD]40HC[/TD]
[TD]Insert check here[/TD]
[/TR]
[TR]
[TD]DEF654321[/TD]
[TD]1[/TD]
[TD]40ST[/TD]
[TD]x[/TD]
[TD]BKG not Found[/TD]
[TD]#N/A[/TD]
[TD]Inserd red X here[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

You can use this formula for your CF:

Book1
	A	B	C	D	E	F	G	H
1	Boking	QTY	Size	x	Term Qty	Term Size	CF Icon Set
2	ABC123456	5	20ST	x	5	20ST	FALSE	TRUE
3	ABC654321	3	40HC	x	BKG not Found	#DIV/0!	TRUE	FALSE
4	DEF123456	10	40HC	x	10	40HC	FALSE	TRUE
5	DEF654321	1	40ST	x	BKG not Found	#N/A	TRUE	FALSE
Sheet3

Cell Formulas
Range	Formula
G2	=ISERROR(SUM(A2:F2))
H2	=NOT(ISERROR(SUM(A2:F2)))