Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows or format values based on another cell. Using the formula feature in conditional formatting is tricky. I share the secret to getting it right every time.
In the beginning days for any Excel user, there seems to be an unavoidable event that occurs. You’re cruising along typing in data and writing simple formulas. Then you are shown that a formula can be repeated across many rows of data using Fill Series or copy/paste. But then, IT happens!