If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Excel conditional formatting made easy! Learn formulas, advanced techniques, and troubleshooting tips to enhance your data analysis skills.

Scrolling through rows of billing data, discovery deadlines, and other Excel related information to manually highlight follow-up items can feel like a never-ending chore. With the use of Excel’s ...

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

TL;DR Key Takeaways : Conditional formatting issues in Excel often arise from the use of relative references, leading to fragmented or duplicated rules when rows are inserted. The OFFSET function ...

Within the Conditional Formatting function, Google has provided the option of using custom formulas. These custom formulas are what you'll have to use in order to make this thing work.