Conditional formatting using icon set to show trend AND colour coding of cell based on a %

[Laura_PinksBTHFT]

Hi,
I have created a dashboard in Excel and have two columns of data (showing percentages or numbers) to show this month/last month figures. I then have a comparison column showing the % up or down based on a formula. Assigned to this column I have conditional formatting set to 'icon set' which gives me the % increase/decrease but with an up, down or same arrow at the side to show the trend. What I can't fathom is how to also add in a rule to colour code the cell on a red, amber, green basis to show red if below 85%, amber 85-94.9% then green as 95%+.
I can only get the cell to carry out the icon set formatting and am manually changing the colour of the cell to green, red etc. Is there a way to do this please?

 

[etaf]

have you used the ICON set thats coloured

dont use % - us a number
so Green > 0.95
Amber >0.85

Book1
	A
1	100%
2	99%
3	98%
4	97%
5	96%
6	95%
7	94%
8	93%
9	92%
10	91%
11	90%
12	89%
13	88%
14	87%
15	86%
16	85%
17	84%
18	83%
19	82%
20	81%
21	80%
22	79%
23	78%
24	77%
25	76%
26	75%
27	74%
28	73%
29	72%
30	71%
31	70%
32	69%
33	68%
Sheet1

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