Hello everyone,
I would like from a selection of a range, color the nearest value from the average of that range. (ONLY WITH A VBA CODE)
I don't know if it's clear but here is my VBA code (it's not working of course), and below the excel file sheet Exercice3 to understand better my demand.
So I want when I select a random area in sheet exercice 3 to color the cell that have the nearest value from the average.
Thank you by advance.
I would like from a selection of a range, color the nearest value from the average of that range. (ONLY WITH A VBA CODE)
I don't know if it's clear but here is my VBA code (it's not working of course), and below the excel file sheet Exercice3 to understand better my demand.
So I want when I select a random area in sheet exercice 3 to color the cell that have the nearest value from the average.
Thank you by advance.