Excel Pivot Table
How to Apply Conditional Formatting in Excel Pivot Table
Learn how to apply conditional formatting in Excel Pivot Tables using the formatting icon or by creating a new conditional rule.
Read article
#Excel Conditional Formatting
24 articles tagged with “Excel Conditional Formatting”
Excel Pro Tips
How to Highlight Entire Row in Excel with Conditional Formatting
Learn how to highlight entire row in Excel with conditional formatting using cell values, numeric criteria, logical functions or dropdowns.
Read article
Excel Pro Tips
How to Show Data Bars with Percentage in Excel (3 Suitable Ways)
Learn how to show data bars with percentage in Excel using conditional formatting, the REPT function, and options for negative values.
Read article
Excel Pro Tips
How to Apply Conditional Formatting to Blank Cells in Excel
Learn how to apply conditional formatting to blank cells in Excel using the built-in “Blanks” option, ISBLANK, OR, LEN functions & formulas.
Read article
Excel Pro Tips
Excel Conditional Formatting Based on Another Cell Range
Learn how to apply Excel conditional formatting based on another cell range using operators, text rules, AND/OR logic, and VBA.
Read article
Excel Pro Tips
How to Copy Conditional Formatting to Another Sheet in Excel
Learn how to copy conditional formatting to another sheet in Excel using Format Painter, Paste Special, rule manager, or VBA automation.
Read article
Excel Pro Tips
Conditional Formatting to Highlight Overdue Dates in Excel
Learn how to use conditional formatting in Excel to highlight overdue dates with formulas, COUNTIF, partial matches and dynamic named ranges.
Read article
Excel Pro Tips
Conditional Formatting Based on Another Cell with Multiple Values
Learn how to apply conditional formatting based on anothr cell with multiple values using OR, COUNTIF, partial matches, and named range
Read article
Excel Pro Tips
Highlight a Cell in Excel if Value Is Greater Than Another Cell
Learn how to highlight a cell in Excel if its value is greater than another cell using conditional formatting, formulas, and built-in rules.
Read article
Excel Pro Tips
How to Add Data Bars in Excel (with Customizations)
Learn how to add data bars in Excel using conditional formatting, customize them, and apply them to pivot tables and formulas.
Read article
Excel Pro Tips
Excel Conditional Formatting to Compare Two Columns
Learn how to use conditional formatting in Excel to compare two columns and highlight matching or unique values easily.
Read article
Excel Pro Tips
How to Apply Conditional Formatting to the Selected Cells (5 Ways)
This article shows 5 ways to apply conditional formatting to selected non-adjacent cells, two columns, with formulas, & data bars option
Read article