When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.