If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

I'll freely admit I'm no Excel expert so this may be incorrect, but I've found Excel treats times as numbers. 6:00 AM = .25, 12:00 PM = .5 et cetera. The conditional in the formula above reflects ...

How to Allow Value Changes to Excel Protected Cells Using Macros. Microsoft Excel normally does not let users change the values of protected cells. To edit a protected cell, you must first remove ...

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.