8

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

13

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 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.

  • 1
    Worked very well. I ended up using " =AND(NOT(ISBLANK(C2:C)),(ISBLANK(D2:D))) ". Because I didn't want the D column to be formatted if it had text.(Forgot to include that in my message). Thank you very much :) – Aethroz Oct 7 '15 at 18:48
  • 5
    Critical to have the = in front of the conditional statement. So =NOT(ISBLANK(C2:C)) works, but NOT(ISBLANK(C2:C)) will not. Hopefully saves some people some time! Google Sheets is so powerful but definitely has some documentation concerns especially for folks coming from Excel. – Shane Oct 23 '17 at 12:02
  • 1
    UPDATE - Now conditional formatting has a "Cell is empty" condition as a provided option. – Matt Jun 20 '18 at 15:24
  • But remember, sometimes a cell isn't quite empty, and isn't quite blank, but still might be =="" so C2:C=="" might be a good check when the others don't seem to work. – Victoria Aug 9 '18 at 5:29

protected by Community Jun 12 at 10:28

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.