You can use the AND function. For example, to colour row2 if B2 is >50
and C2 is not blank:
1. Select row 2
2. Choose Format>Conditional Formatting
3. From the first dropdown, choose Formula Is
4. In the formula box, type: =AND($B2>50,$C2<>"")
5. Click the Format button, and choose the formatting options.
6. Click OK, click OK
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
