Apply Conditional Formatting based on multiple conditions

excel excel-2010 conditional-formatting
ngwilliams picture ngwilliams · Aug 6, 2013 · Viewed 58.3k times · Source

I'm attempting to highlight a cell based on two conditions, if the Work Type is equal to (blank), and if the cell itself is greater than 15%, then I want the cell under % Total Work highlighted. My sheet looks like this:

enter image description here

The only way I can think to do this is using the AND function, something like =AND($B:$B="(blank)";$D:$D>.15), but this produces an error. I'm very new to conditional formatting, so I may be missing something obvious. I'm using Excel 2010.

Answer

barry houdini picture barry houdini · Aug 6, 2013

You have to apply the formula that applies to the first cell in the range, so if you select the range D8:D100 or similar (where data starts at row 8) then apply this formula in conditional formatting

=AND(B8="(blank)";D8>0.15)

That should do what you need

Related questions

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 only permit different colors based on positive/negative values. I'm currently using Excel 2010. I would like to have the color …

Read More
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 next to it) with the hex color within the cell. I've read a bit about "conditional formatting", and I think …

Read More
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: ...the cells are colored by the cell's raw value. What I would like to do is color by the cell's …

Read More