Top "Conditional-formatting" questions

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

Search a cell for specific 'special characters' and color the cell red if found

I want to search a column of cells for any of these special characters: ` ‘ “ \ / ^ If present (that can also be …

excel conditional-formatting
Excel - Conditional Formatting - insert row

Using Offset or Indirect in 'Applies To' does not seem to work. Is there any other way to stop conditional …

excel conditional-formatting
How do I apply colors to a SharePoint List, based on Status?

I would like to apply colours to a SharePoint List's rows based on status or similar. Please could someone tell …

sharepoint conditional-formatting
Change cell color in Excel according to adjacent dropdown value

I understand how to make a dropdown list. I understand how to make conditional formatting change the color of a …

excel conditional-formatting
Excel: Highlighting a whole column depending on date

I have made my own Gantt chart in Excel, which is shown in this picture: . I would like to highlight …

excel conditional-formatting
Conditional formatting to hide cell content even when printed

I would like to set up a conditional formatting setting that would hide the contents (the cell should look blank) …

excel conditional-formatting excel-2008
Conditional formatting with the icon set and a formula

Basically I am trying to use the conditional formatting icon set that is a green dot, orange dot and red …

excel vlookup conditional-formatting excel-2011
Conditional Formatting - Color Scale entire row based on one column

Suppose I want to color scale complete rows on the basis of values in a column (using excel inbuilt color …

excel conditional-formatting vba
Excel 2010 - Conditional formatting, color adjacent cells in same row

Is is possible in Excel 2010 to set a conditional formatting rule to highlight all not empty cells in a row …

excel conditional-formatting