I was wondering if there is any way of entering code in VBA or within a document to specify that if a certain cell is coloured yellow, then perform a certain equation on that cell or one adjacent to it.
In short, I wish to multiply the earnings of a person if they are in the top 5 sellers. Cells related to people in the top 5 are highlighted yellow.
I therefore wish to be able to colour these 5 cells yellow, automatically multiplying the values by 25%.
Is this possible.