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!

Boking	QTY	Size	x	Term Qty	Term Size	CF Icon Set
ABC123456	5	20ST	x	5	20ST	Insert check here
ABC654321	3	40HC	x	BKG not Found	#N/A	Insert red X here
DEF123456	10	40HC	x	10	40HC	Insert check here
DEF654321	1	40ST	x	BKG not Found	#N/A	Inserd red X here
			x

<tbody>
</tbody>

 

[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)))