Skip to main content

Excel Tips: Format > Conditional Formatting

Conditional Formatting by Dates

How to alter about approaching due date/deadline in Excel?

How to conditional format dates less than/greater than today in Excel?

How to conditional formatting based on date in Excel?

How to conditional formatting red amber green based on date in Excel?

How to highlight cells between two dates in Excel?

How to highlight row if cell contains date in Excel?

How to highlight rows based on date in Goolge sheet?

How to highlight rows if dates have passed in Excel?

How to highlight rows with weekend days in Excel?

How to highlight the date of current day / week / month in Excel?

How to highlight the dates over a year old in Excel?

How to highlight/conditional formatting dates older than 30 days in Excel?

How to identify or highlight expired or upcoming dates in Excel?

How to quickly insert a line based on current date in Excel?

Conditional Formatting by Numbers

How to conditional formatting values not between two numbers in Excel?

How to highlight consecutive or non-consecutive numbers from a column in Excel?

How to highlight multiples of a specific number in Excel?

How to highlight odd or even numbers in Excel?

How to highlight the closest value in a list to a given number in Excel?

How to highlight whole numbers in Excel?

Conditional Formatting by Specific Values

How to apply conditional formatting search for multiple words in Excel?

How To Change Background Or Font Color Based On Cell Value In Excel?

How to change font color based on cell value in Excel?

How to conditional format cells if containing #N/A in Excel?

How to conditional formatting based on another sheet in Google sheet?

How to conditional formatting cells which end with a string in Excel?

How to conditional formatting if the cell contains partial text in Excel?

How to format entire row based on one cell in Excel?

How to grey out cells based on another column or drop down list choice in Excel?

How to highlight all error cells in Excel?

How to highlight cell based on adjacent cell value in Excel?

How to highlight cell if value exists in or equals to cell in another column in Excel?

How to highlight row if cell contains text/value/blank in Excel?

How to highlight rows based on drop down list in Excel?

How to highlight rows based on multiple cell values in Excel?

How to quickly change font size based on cell value in Excel?

How to shade a cell based on another cell value in Excel?