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
Conditional Formatting
19 lessons in order
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 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
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
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
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
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
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 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
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
Conditional Formatting for Dates Older Than Today in Excel
Learn how to highlight dates older than today in Excel using the TODAY function or a VBA macro for automatic formatting.
Read article
Excel Pro Tips
Excel Conditional Formatting Formulas If Cell Contains Text
Learn how to use Conditional Formatting formulas in Excel to highlight cells containing specific, partial or multiple text values.
Read article
Excel Pro Tips
Excel Conditional Formatting Rules Based on Another Column
Learn how to set conditional formatting rules for a column based on another column in Excel using formulas for numbers & text conditions.
Read article
Excel Pro Tips
Excel Conditional Formatting Based on a Date in Another Cell
Learn how to apply conditional formatting based on dates in another cell, including highlighting before, after, equal & row-based date rules.
Read article
Excel Pro Tips
Excel Conditional Formatting to Highlight Dates Within 30 Days
Learn how to use Excel conditional formatting to highlight dates within 30 days using TODAY and AND for dynamic tracking and accuracy.
Read article
Excel Pro Tips
How to Remove Conditional Formatting in Excel
Learn how to remove conditional formatting in Excel using Clear Rules, Quick Analysis, Paste Special, Clear Format, or VBA automation.
Read article
Excel Pro Tips
How to Make Yes Green and No Red in Excel (5 Examples)
Make Yes green and No red in Excel using conditional formatting, filters, VBA Editor, or Office Scripts for highlights easily.
Read article
Excel Pro Tips
How to Use Conditional Formatting Based on VLOOKUP in Excel
Learn how to use conditional formatting with VLOOKUP in Excel to highlight values, compare targets, and explore XLOOKUP, MATCH and VBA.
Read article
Excel Pro Tips
How to Use IF Statement in Excel Conditional Formatting
Learn how to use the IF statement in Excel conditional formatting with helper columns, direct formulas, and VBA to highlight results.
Read article