# Questions tagged [conditional-formatting]

Spreadsheet feature that allows automatically adding color, text styles, etc. to certain cells or ranges of cells based on the data workbook

**0**

**2**answers

### Conditinal Formatting to highlight the first 5 similar cells with a specific text (not the TOP 5)

**0**

**0**answers

### Macro validation and conditional check

**0**

**1**answer

### #VALUE! error using excel 2016 nested IF statements

**0**

**1**answer

### Conditional Formatting in cell based on cell value

**0**

**1**answer

### compare values in excel and highlight the leading number in B1

**0**

**0**answers

### Conditional format against another cell date

**0**

**0**answers

### Excel - automatically updating cell reference when applying conditional formatting to range

**0**

**1**answer

### Highlight a cell based on adjacent value only if it is greater than plus or minus 30 difference

**1**

**1**answer

### Excel Formatting for Symbols

**0**

**0**answers

### Conditional Formatting based on the result of a formula, not the in cell formula

**1**

**1**answer

### Condition format color cells until sum equal to another cell

**0**

**2**answers

### Why is this excel conditional formatting rule removing the cell gridlines?

**0**

**1**answer

### Hiding #DIV/0! in cells with conditional formatting

**0**

**1**answer

### MS Excel How to Hide or Change Color of text in a cell with no value

**1**

**1**answer

### How do I highlight cells in column A that match text in column B?

**0**

**1**answer

### How do i make different words (in column A1, A25, A37) automatically show a value (in column B1, B25, B37)

**0**

**2**answers

### How do i make a word (in column A1) automatically show a value (in column B1)

**0**

**1**answer

### How do i make a word (in column A) automatically show a corresponding value (in column B)

**1**

**1**answer

### How do I highlight duplicate cells across 3 columns for multiple rows?

**0**

**2**answers

### Specifying Today's Tasks in Excel in a seperate column, for seperate products and separate clients

**1**

**1**answer

### Conditional Formatting - Looking for cells not including two particular characters followed by two numbers

**0**

**2**answers

### Conditional formatting in Excel not working on cell content added dynamically by Microsoft Flow

**0**

**2**answers

### Excel highlight cell (text) that equals one of multiple other cells

**0**

**0**answers

### Excel: Power Query >Table resizing to fit results > Havoc with conditional formatting

**0**

**2**answers

### How to hide formula result until data is entered in at least 5 of the 7 cells

**0**

**1**answer

### Conditional formatting based on value of adjacent cell

**0**

**1**answer

### Excel Highlight Cells Greater than

**0**

**1**answer

### Conditional Formatting one column of date/time data compared to another colum date/time data 4 hour breach and 1 hour breach

**0**

**0**answers

### How to conditionally format an entire column based on the value of the first cell of the column?

**0**

**0**answers

### Keep most recent formatting if conditional formatting stop? (MS Excel 2016)

**0**

**1**answer

### Excel on Mac Conditional Formatting - Exceptions

**0**

**1**answer

### Conditional formatting based on cell reference

**0**

**1**answer

### Conditional format if column contains value and those rows contain another value

**1**

**2**answers

### Conditional format range of cells based on one cell matching another cell

**-1**

**1**answer

### Excel Conditional formatting to highlight other cell based on another cells text. Specifically a letter tied to a string of numbers

**0**

**1**answer

### Conditional formatting fill pattern

**0**

**0**answers

### Match color of color-scale conditionally formatted cell in another cell

**0**

**1**answer

### Apply conditional formatting on different column as the column with the conditional formula

**1**

**2**answers

### Conditional formatting only values in range in Excel

**0**

**0**answers

### Apply conditional formatting data bars to different cells in Excel

**1**

**1**answer

### Multiple Conditional formatting to highlight a third cell when two cells match

**0**

**1**answer

### How to drag conditional formatting (only) across columns using relative reference values

**1**

**1**answer

### formatting a number as text

**0**

**1**answer

### Excel conditional formatting to compare cell values within a row

**0**

**1**answer

### VLOOKUP Syntax for Conditional Formatting Rule

**0**

**1**answer

### Conditional Formatting for multiple cells and ranges in excel

**0**

**2**answers

### Excel Conditional Formatting if another column contains data

**0**

**1**answer

### EXCEL - How can I use conditional formatting to color code if this week's value has increased by more than 5% from the previous week's value?

**0**

**0**answers

### Conditional Formatting to combine multiple entries / dates

**0**

**1**answer