Insert of Shape

[vmjan02]

I am not sure is it possible in excel I have a cell values from M6 to M16, the code should insert the shapes with respect to cell values.

eg:- if the cell value is >0% then code should insert the triange shape with colour Green
if the cell value is <0% then code should insert the triange shape with colour Red and should rotate down
if the cell value is =0% then code should insert the Rectangle shape with colour gray height(0.08'') and width(0.37'')

I have tryied many options and non is working for me condition formation is not giving the corret results, is there a way out of this.

Note from M6 to M16 the cell values may change.

 

[Anthony47]

A "different" approach:
-in N6 insert the formula =M6
-copy N6 up to N16
-select N6:N16 and apply the font Wingdings 3
-select N6:N16; right-click, select Format cells; under the tab Number, select Category=Custom, in the Type box insert [Green]"p";[Red]"q";[Black]"¬", complete with Ok

For the Custom format codes, see Number format codes - Microsoft Support

The XL2BB minisheet show the Excel point of view, and the image shows the visual output:

MULTI_C30822.xlsm
	M	N
5
6	22%	p
7	-23%	q
8	0	¬
9	5%	p
10	3%	p
11	11%	p
12	0%	¬
13	-7%	q
14	-9%	q
15
Foglio4

Cell Formulas
Range	Formula
N6:N14	N6	=M6

 

[Peter_SSs]

Why not use Excel's built-in Conditional Formatting (Icon Sets). Set up like this:

Here is the result:

 

[Muhammad_Usman]

Here is an other option

[Color10]0% ▲;[Red]-0% ▼;[Color16]–

 

[vmjan02]

Here is an other option


View attachment 97615



[Color10]0% ▲;[Red]-0% ▼;[Color16]–

Hi this is working perfect as required only one change

[Color10]>0% ▲;[Red]-0% ▼;[Color16]0%(circle) -- can this be done
If the value is 0% then a circle with grey colour

 

[vmjan02]

A "different" approach:
-in N6 insert the formula =M6
-copy N6 up to N16
-select N6:N16 and apply the font Wingdings 3
-select N6:N16; right-click, select Format cells; under the tab Number, select Category=Custom, in the Type box insert [Green]"p";[Red]"q";[Black]"¬", complete with Ok

For the Custom format codes, see Number format codes - Microsoft Support

The XL2BB minisheet show the Excel point of view, and the image shows the visual output:

MULTI_C30822.xlsm
	M	N
5
6	22%	p
7	-23%	q
8	0	¬
9	5%	p
10	3%	p
11	11%	p
12	0%	¬
13	-7%	q
14	-9%	q
15
Foglio4

Cell Formulas
Range	Formula
N6:N14	N6	=M6

if its 0% then a circle is required, can this be possible

 

[Muhammad_Usman]

Hi this is working perfect as required only one change

[Color10]>0% ▲;[Red]-0% ▼;[Color16]0%(circle) -- can this be done
If the value is 0% then a circle with grey colour

[Color10]0% ▲;[Red]-0% ▼;[Color16]Ꙩ
Try this one