Always use Relative cell references/addresses (the default ... See my Excel macro tips article for detailed instructions. 2. Use specific VBA code with directional keys Always use directional ...

If they enter the wrong cell reference, Excel won’t highlight ... (They probably won’t have the VBA expertise to update the original macro code.) The rule applies yellow highlighting just ...

This has helped a few users fix the issue. If none of the above methods help, you may use a VBA code to force highlight cell references in a formula in Excel. Open the workbook and go to the ...