Menu
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:
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.
489
asked Aug 06 '13 19:08
Step 1) Please select range D2:D13. Step 2) Go to Home tab > click on Conditional Formatting drop-down > click on New Rule > click on Use a formula to determine which cells to format > write the formula: =C2="started". Step 3) Click on Format to apply formatting. Click on OK . .
Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.
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
65
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
