Top "Conditional-formatting" questions

Conditional formatting is a technique, where cells of a table are formatted depending on cells evaluated value or other conditions.

Excel conditional formatting based on cell and adjacent cell values

Is it possible to format a cell in Excel based on the cell above it's value. Basically I'm compiling a …

excel conditional-formatting
Using VBA to apply conditional formatting to a range of cells

I would like to know how to access the column in conditional formatting titled 'Applies To' and input my own …

vba excel conditional-formatting
If cell contains 1 or more keywords, change value of a different cell

I have a column with some string description in it. for example: Bob davids mowing the lawn tipping cows In …

excel conditional-formatting vba
Using conditional formatting to highlight a row if the date in the column F equals todays date

How would I get a row in my table to highlight if the date in the column F equals todays …

excel conditional-formatting
Conditional formatting if a cell does not equal one of three values

I have a dataset as below: I want to apply conditional formatting that will format a cell if the value …

excel excel-formula conditional-formatting
Excel Conditional Formatting based on Other Column

I have two columns in Excel as shown on the picture below. I need to apply conditional formatting in this …

excel conditional-formatting
Excel Conditional Formatting Data Bars based on Color

I cannot find a way to change the color of an Excel data bar based on value. Current formatting options …

excel excel-2010 conditional-formatting vba
Multiple conditional formatting rules across multiple ranges?

I need to do the following. Highlight a row if cell E contains a number greater than 30 AND cell L …

excel excel-formula conditional-formatting
How to highlight a cell using the hex color value within the cell?

I have a spreadsheet of symbols and matching hex colors. I want to fill the cell itself (or the one …

vba excel excel-2010 conditional-formatting
Apply Conditional Formatting based on multiple conditions

I'm attempting to highlight a cell based on two conditions, if the Work Type is equal to (blank), and if …

excel excel-2010 conditional-formatting