Microsoft Excel’s OR () function will help us find the top-three ranking values: 1, 2 and 3. We’ll use the OR () function in our conditional format formula.

To create formula-based rules, select a range, use the “New Rule” option under “Conditional Formatting,” and input a formula with appropriate cell references.

That’s what I mean by a multi-column duplicate. And, we’re assuming you don’t want to use a custom conditional rule. Figure A We’ll add a formula solution that spots duplicates.

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells.

Conditional formats add color, shading or icons to data records that match certain criteria. Excel gives you complete control over the conditional formatting in your workbook, allowing you to ...

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

With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

How to use ISNUMBER in conditional formatting? Highlight the range of cells. Go to the Home tab, click the Conditioning Formatting button in the Styles group, then select New Rule. A New ...

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.

Method for Excel 2010 For Excel 2010, right-click on the cell that contains the conditional formatting to move to other cells. Click Copy from the pop-up menu.