Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Excel Tips: Format > Conditional Formatting

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

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?

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?