Log in
x
or
x
x
Register
x

or

Excel Tips: Format > Conditional Formatting

Conditional Formatting Blank or nonblank cells

How to highlight non-blank cells in Excel?

How to shade a blank cell until something is entered in Excel?

How to shade or color blank cells or nonblank cells in Excel?

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?

Conditional Formatting Duplicate or Unique Values

How to color duplicate values or duplicate rows in Excel?

How to conditional format or highlight first occurrence (all unique values) in Excel?

How to conditional formatting duplicate cells in a column in Google sheet?

How to find and highlight the duplicate names which both match first name and last name in Excel?

How to highlight cells if not in another column in Excel?

How to highlight cells with same/duplicate values in Excel?

How to highlight column differences in Excel?

How to highlight consecutive duplicate cells from a list in Excel?

How to highlight duplicate rows across multiple columns in Excel?

How to highlight duplicate values except first instance in Excel?

How to highlight duplicate values in different colors in Excel?

How to highlight the duplicates and overlapping dates in Excel?

How to highlight the last duplicate row/cell in Excel?

How to highlight/conditional formatting unique/duplicate values in Excel?

Highlight Top or Bottom Items

How to highlight cells above/below average in Excel?

How to highlight largest / lowest value in each row or column?

How to highlight max and min data points in a chart?

How to highlight or conditional formatting the max or min value in Google sheet?

How to highlight/conditional formatting top n values in Excel?

Icon Sets

How to change conditional formatting icon set color in Excel?

How to compare adjacent cells with Conditional Formatting icon sets in Excel?

How to create a five-star rating system in Excel?

How to use icon sets to highlight values in conditional formatting in Excel?

Format Scope

How to apply conditional formatting across worksheets/workbooks?

How to auto-highlight row and column of active cell in Excel?

How to conditional formatting only in Excel visible cells?

How to highlight / fill every nth row or column in Excel?

How to highlight active cell or selection in Excel?

How to highlight all named ranges in Excel?

How to highlight all subtotal rows at once in Excel?

How to highlight entire / whole row while scrolling in Excel worksheet?

How to highlight locked cells in Excel

How to highlight selected row / column / column and row in Excel?

How to highlight the last row/cell in Excel?

How to highlight/color unlocked cells in Excel?

How to quickly crosshair highlight active cell in Excel?

How to quickly shade alternating filtered rows in Excel?

How to shade every other column in Microsoft Excel?

How to shade every other or alternate rows in Excel?

Others

Data Bar

How to create data bar with conditional formatting in Excel?

Clear Rules

How to quickly remove conditional formatting in Excel?

How to remove conditional formatting but keep format in Excel?

How to remove conditional formatting from blank cells in Excel?

 

Change chart color based on value in Excel

How to add border to cells by using If statement in Excel?

How to color coded drop down list in Excel?

How to conditional format cells based on first letter/character in Excel?

How to conditional formatting based on frequency (the most common number/text) in Excel?

How to conditional formatting data based on percentile rank in Excel?

How to conditional formatting pivot table in Excel?

How to conditional formatting smiley face chart or font in Excel cells?

How to copy conditional formatting rules to another worksheet/workbook?

How to count/sum cells by colors with conditional formatting in Excel?

How to create a chart with conditional formatting in Excel?

How to highlight / conditional formatting cells with formulas in Excel?

How to highlight all cells referenced by a formula in Excel?

How to highlight all cells with comments in Excel?

How to highlight all misspelled words in worksheet in Excel?

How to highlight cell or row with checkbox in Excel?

How to highlight cells based on length of text in Excel?

How to highlight cells with external links in Excel?

How to highlight column or column header if it is filtered in Excel?

How to highlight precedent or dependent cells in Excel?

How to highlight rows when cell value changes in Excel?

How to highlight specific text within a cell based on other text?

How to highlight the cells linked by hyperlinks in Excel?

How to highlight the modified/updated cells in Excel?

How to highlight winning lottery numbers in Excel worksheet?

How to ignore blank or zero cells in conditional formatting in Excel?

How to print all conditional formatting rules in a worksheet?

How to protect conditional formatting rules in Excel?

How to remove (temporarily hide) conditional formatting when printing in Excel?

How to use conditional formatting to create a Gantt chart in Excel?

How to use Stop If True when conditional formatting in Excel?