Formula for using with Icon Sets

[jonespandrew]

Hi there I am trying to create a formulae with conditional formating using the i con sets, this is what i want it to do

I have a cell called outstanding stock say c3, i am trying to do a formulae that says if c3 is not equal to 0 the the condional formatin will but the yellow ! mark next to that field, any ideas

 

[etaf]

i used the icon set with a yellow ! for the middle value
then i changed the values to numbers
and then >0
and for the ! >= 0

not sure if xl2bb works

motorhome.xlsx
	A
1	0
2	1
3	2
4	4
5	-5
6	-8
7	0
8	0
9	0
10	0
11
Sheet2

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