Skip to main content

Excel Tips: Developer > Macro or VBA

Format

Format > Conditional Formatting

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

How to highlight active cell or selection in Excel?

How to highlight all cells with comments in Excel?

How to highlight all misspelled words in worksheet in Excel?

How to highlight all named ranges in Excel?

How to highlight all subtotal rows at once in Excel?

How to highlight cell or row with checkbox in Excel?

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

How to highlight duplicate values in different colors in Excel?

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

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 quickly change font size based on cell value in Excel?

How to quickly crosshair highlight active cell in Excel?

How to quickly shade alternating filtered rows in Excel?

Format > Format Cells

How to add border line below when value changes in an Excel column?

How to align duplicates or matching values in two columns in Excel?

How to apply color gradient across multiple cells?

How to auto-center checkbox in cell 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 text when concatenate two columns in Excel?

How to change border color of active cell in Excel?

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

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

How to convert date from dot to slash format in Excel?

How to format mac addresses in cells by adding colon symbol in Excel?

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

How to keep cell formatting while referencing other sheet cells?

How to make cell flash red in Excel?

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

How to preserve grid lines while filling color in Excel?

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

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

How to shrink text to fit a cell in Excel?

How to unmerge cells and fill with duplicate values in Excel?

Format > Others

How to auto fit column width in Excel?

How to auto fit row height of merged cells in Excel?

How to change the row height / column width alternated in Excel?

How to change the row height based on cell value in Excel?

How to display date format in combo box output in Excel?

How to protect cell formatting but only allow data entry in Excel?

How to quickly restore to default cell size in Excel?

How to remove tab color in Excel?

How to resize multiple cells to fit pictures quickly in Excel?

How to set cell size in cm (centimeters) in Excel?

How to specify date or datetime format in header or footer?

How to square multiple cells in Excel?