Skip to main content

Excel Tips: Format > Format Cells

Fill Color

How to alternate row color based on group in Excel?

How to apply color banded rows or columns in Excel?

How to apply color gradient across multiple cells?

How to apply shading to odd or even (alternative) rows/columns in Excel?

How to automatically color alternating rows/columns in Excel?

How to compare two columns and highlight the unmatched data in Excel?

How to compare two columns and highlight when found in another column?

How to compare two columns for (highlighting) missing values in Excel?

How to determine and identify the background color index of cells in Excel?

How to format cell to look like a 3D button in Excel?

How to half shade cell in Excel?

How to make cell flash red in Excel?

How to mark duplicate values with color in Excel?

How to randomly add background/fill color for cells in Excel?

How to remove fill color from cells in Excel?

How to select and highlight diagonal cells in Excel?

How to select and highlight row differences in Excel?

How to set cell color equal to another cell color in Excel?

Font

How to add or remove strikethrough in Excel?

How to auto strikethrough based on cell value in Excel?

How to bold all specific words in a range of cells?

How to bold only the first line or first word in cell in Excel?

How to bold part of text string in a cell in Excel?

How to bold part text when concatenate two columns in Excel?

How to bold text in checkbox in Excel?

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

How to change cell color when cell is clicked or selected in Excel?

How to change color if two cells are not equal in Excel?

How to change default font in Excel?

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

How to change font color for part of text in cell in Excel?

How to change the strikethrough color without changing the color of the text in Excel?

How to color duplicate values or duplicate rows in Excel?

How to color or highlight certain word in cells in Excel?

How to compare two strings for similarity or highlight differences in Excel?

How to format part text as superscript or subscript within a cell?

How to format single character in selected cell in Excel?

How to format text as subscript in Excel 2007/2010?

How to format text as superscripts in Excel 2007/2010?

How to increase or decrease the font size with shortcut key in Excel?

How to make cells bold if greater than certain number in Excel?

How to prevent hyperlinks from changing color in Excel?

How to subscript all numbers in chemical formulas in Excel?

How to use multiple font colors or fonts in one cell in Excel?