I'd like to format cell A338 so that, if that cell is blank and if cell H338 is not blank, then conditional formatting would apply.


That didn't work. Where's my error?

  • I've aslo tried a different approach and didn't work: ==and(len(h338>0),len(a338)<0)
    – Olga
    Jun 2, 2017 at 14:59
  • The issue might be data validation that I have in A338. I've aslo tried a different approach and didn't work: ==and(len(h338>0),len(a338)<0) Cell A338 has data validation, if I test these two formulas separately, the len(a338)<0) is the one that doesn't work on its own. My overall problem is that if I have an IF formula in cell A338 saying "Fill Out" if H338 is not blank, then I cannot click on the data validation arrow to select the answer for cell A338, so I thought I'd go the conditional formatting route.
    – Olga
    Jun 2, 2017 at 15:52

1 Answer 1


Select A338 and apply a Custom formula is of:


with formatting of choice and Done.


You were, presumably, not applying your formula to the correct range.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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