0

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.

=AND(NOT(ISBLANK($H338)),(ISBLANK($A338)))

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 '17 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 '17 at 15:52
1

Select A338 and apply a Custom formula is of:

=and(A338="",H338<>"")

with formatting of choice and Done.

AND

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, privacy policy and cookie policy

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