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:


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

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

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


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


| improve this answer | |
  • 1
    first one worked perfectly thank you!! not sure how Len applies 🤷‍♀️ – Mari Jun 12 '19 at 16:16
  • 1
    LEN is kinda opposite of ISBLANK – user0 Jun 12 '19 at 16:33

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.