Google Sheets – Apply Conditional Formatting if Cell is Not Empty

conditional formattinggoogle sheets

2 Columns. 

C2 | D2  
C3 | D3  
C4 | D4  
C5 | D5

I want it to apply conditional formatting to D2 if C2 has information in it, and D2 is blank. (will be a date). If C2 is empty, then D2 should have no formatting. I don't want D2 to be formatted if C2 has text, and D2 has text.

Picture: I would want it to look like this:

Example

Best Answer

The ISBLANK formula should serve your purpose well.

Create a new rule in the conditional formatting menu. Set the range of your rule to D2:D so that the formatting is applied to column D. Then, in the Condition dropdown menu, select "Custom formula is." In the input field, enter =NOT(ISBLANK(C2:C)). (The = implies the rest is a formula. The NOT formula negates the value returned by its argument. Since you want the formatting rule to apply if the corresponding cell in column C is NOT empty, you will need to use this.) Finally, set the formatting to suit your needs.

Related Topic