how do yo can add colum %desv and show semaphore with macros

[pakilprogramador]

hi all,
Please, how do you can add column % DEV and compare the two bills and show semaphore .

for example



regards,

 

[pakilprogramador]

any idea please.

thanks

regards,

 

[NARAYANK991]

Hi ,

First , I do not know why you want a calculated field to be inserted using VBA ; you can easily insert the formulae , and since the number of columns is fixed , you can always have these 2 columns on the extreme right , so that even if the data changes , these 2 columns will never be affected.

Secondly , I have no idea how you want the icons to operate , but you can see that using Percent and using Number gives different results ; you need to decide which you want.

Narayan

 

[pakilprogramador]

hi @NARAYANK991,

the idea is to compare the bill October to September
for example
compare k12 - k27 =% Desv. (L12) = -3.37
compare k13 - k28 =% Desv. (L13) =-1.25
compare k14 - K29 =% Desv. (L14) =-1.97
compare k15 - k30 =% Desv. (L15) =-6.96
..
...
...

for example ut in range k12 semaphore red this is menor , and range k27 semaphore green this is major etc.

 

[NARAYANK991]

Hi ,

I am not sure I understand what you want. Can you see this file and comment ?

Narayan

 

[pakilprogramador]

double click at agencia 1 , agencia 2, agencia 3 add and calculate automatic the column % desv. with its own semaphore.

regards