I would like to get some help to create a macro as I have just joined a firm as a Jr. Analyst - I am still learning Macros - please help..
I would like to change the color of the cell based on the following:
For Column A,B,D,E,L : color highest 2 numbers- RED, lowest 2 numbers -yellow
For column C, if the % is 50% and above then green, if between 50.1% and 45% then blue, if lower than 44.9% then - black