1

I am doing a formula in conditional formatting and I need it to be relative to each of the 1500 rows but it keeps retrieving an absolute value. how do I get around putting a new formatting formula for each row? this is my formula:

=AND(G5<I2,ISBLANK(H5)=True)

need it to be applied, relatively, to E5:E1500.

1
  • formula not showing on post for some reason. it's: =AND(G5<I2,ISBLANK(H5)=True)
    – Mari
    Jun 12, 2019 at 13:18

1 Answer 1

0

=AND(G5 < I$2, ISBLANK(H5))

0


=AND(G5 < I$2, ISBLANK(H5), LEN(G5))

0

2
  • 1
    first one worked perfectly thank you!! not sure how Len applies 🤷‍♀️
    – Mari
    Jun 12, 2019 at 16:16
  • 1
    LEN is kinda opposite of ISBLANK
    – user0
    Jun 12, 2019 at 16:33

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.