In this Excel tutorial, I’ll show you how to apply conditional formatting to a filtered PivotTable in Excel. Although the requirement will be a bit complex, it will require no expression to ...

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...

There you can opt to clear conditional formatting from the selected cells, the entire worksheet, the current table, or the current PivotTable. Shimon Brathwaite / IDG It’s easy to remove ...

This month, I received a lot of Excel questions. So in this article, we'll tackle random time values, an icon-displaying conditional expression and format, and a quick PivotTable solution. For ...