• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

apply function into colored range

Afarag

Member
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,
 

Attachments

  • invers.xlsx
    17.2 KB · Views: 6
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,
 

Attachments

  • invers result.xlsx
    30.2 KB · Views: 1
@Afarag
Select Result-tab's 'User name'-cell to do 'Result = 15- Data'.
for testing ...
 

Attachments

  • invers result.xlsb
    26.7 KB · Views: 5
Back
Top