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
