Conditional Formatting

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 »

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 »

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 »

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 »

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 »

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 »