Top "Conditional-formatting" questions

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

Conditionally format Python pandas cell

I am trying to color, highlight, or change fond of Python pandas DataFrame based on the value of the cell. …

python pandas dataframe highlight conditional-formatting
Color cells by absolute value in a range in Excel 2010

I'm looking to color a table of values in Excel 2010 by their absolute value. Basically, if I have the table: ...…

excel excel-2010 conditional-formatting vba
How to format rows to color group by like values in column 1

I have a worksheet that has information like this: a a b c c c How do I format it …

excel colors conditional-formatting
Excel: Conditional formatting for clusters of values

In an EXCEL 2010 spreadsheet, how can I create alternating fill color for clustered cell values, changing when a new value …

excel conditional-formatting
Excel - Copy Conditional Formatting, Remove Rules, Keep Format

I know you usually show what you've tried in a question, but this is more of a "Do you have …

vba excel conditional-formatting
Conditional Formatting percent incorrect Excel

I have the following: So I want 99% and above = Green Between 95% - 99% = Amber Below 95% = Red However above 95% is still red. …

excel conditional-formatting
Conditional formatting based on cell above

Given these cell values in Excel (say column A): 420 420 480 444 445 If the number above is lower, I want the cell to …

excel conditional-formatting
Formula to conditional formatting text that contains value from another cell

I have a column A that contains a 1-4 word phrases in each cell. I also have 4 cells that contain 1 …

excel excel-formula excel-2010 conditional-formatting
VBA function to test if cell is conditionally formatted in Excel

I have written the function below to test if a cell has conditional formatting activated based upon the cell fill. …

excel function vba conditional-formatting
Conditional Formatting by Expression using EPPlus

I'm trying to format some range by using conditional Formatting feature of EPPlus. I read many document but there is …

c# excel excel-2007 conditional-formatting epplus