apply function into colored range

[Afarag]

Hello there,

please i need your support in getting this issue solved





as shown, i need to change the colored cell's values to be (15-the filled #) by VBA code.


gratefully,

 

[vletm]

@Afarag
What would shown?
Which cells values to which values, is there any rules of change?

 

[Afarag]

Hi vletm,

the pic is a snapshot for the uploaded sheet.
i need all colored cell's value to be converted to 15-"the exist value
eg: if the cell have 12 i need to be (15-12)>>3, if it have 0 i need to be filled with 15 etc...

i uploaded a new workbook with the result that i need to get in the sheet which called "result".

there is no rule for converting except of the non colored cells i need to be blank.

thanks a lot,

 

[vletm]

@Afarag
Select Result-tab's 'User name'-cell to do 'Result = 15- Data'.
for testing ...