f you often repeat things in Excel and do not want to have a macro (VBA), you can use the smart key "F4".
The "F4" key repeats your last command / Action, you performed in Excel.
Suppose you are working in a data table and highlighting the high variances with Red color, you do it once using the "Fill Color" option available in Excel and after this just select the cell with high variance and press "F4" and this will fill that cell with Red color.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.