Conditional Formatting

How to Remove Conditional Formatting on Blank Cells in Excel

This post will guide you how to remove conditional formatting if cell is blank in Excel. How do I skip conditional formatting for blank cells in Excel 2013/2016. Remove Conditional Formatting on Blank Cells Assuming that you have a list of data in range B1:B5, in which contain text values and blank cells, and have… read more »

Conditional Formatting Rows by Groups in Excel

This post will guide you how to apply conditional formatting for alternate row color based on groups in your worksheet in Excel. How do I alter row color by groups using conditioanl formatting in Excel 2013/2016. Alternating Rows Color by Groups Assuming that you have a list of data in range A1:B5, in which contain… read more »

How to Highlight Cells Greater Than a Certain Length in Excel

This post will guide you how to highlight a cell that contains more than a certain length using Conditional Formatting function in Excel. How do I highlight cells greater than or less than a certain text length in Excel. Highlight Cells Based on Text Length Assuming that you have a list of data in range… read more »

How to Highlight Dates Older Than 30 Days in Excel

This post will guide you how to highlight dates older than 30 days in Excel. How do I use conditional formatting to highlight if date is greater than 30 days old in Excel. How to highlight a row or cell if it’s older than x days in Excel. Highlight Dates Older Than 30 Days Assuming… read more »

How to Select Cells That Meet Certain Criteria in Excel

This post will guide you how to select cells that meet certain criteria in Excel. How do I find and select cells based on specific types of data in your worksheet in Excel. Select Cells That Meet one Criteria Using Go To Command Find Cells That Meet one Criteria Using Conditional Formatting Select Cells That… read more »

How to Change the Font Color Based on Cell Value in Excel

This post will guide you how to change the font color based on cell value in Excel. How do I color cell based on cell value using the conditional formatting feature in Excel. Changing Font Color Based on Cell Value Video: Changing Font color based on Cell Value Changing Font Color Based on Cell Value… read more »

How to Highlight Blank Cells in Excel

This post will guide you how to highlight blank cells in Excel. How do I use Conditional Formatting to highlight blank cells in Excel. Highlight Blank Cells with Go To Special Feature Highlight Blank Cells with Conditional Formatting Video: Highlight Blank Cells Highlight Blank Cells with Go To Special Feature If you want to highlight… read more »

How to Find and Highlight Duplicate Rows in Excel

This post will guide you how to find and highlight duplicate rows in a range of cells in Excel. How do I find duplicate rows in a range with a formula in Excel. How to find duplicate rows in two or three columns with Conditional Formatting feature in Excel. Find Duplicate Rows Only Find and… read more »

Sidebar