1

I would like all columns that only contain empty cells to light up green.

In the below picture these should be: C3:C8, D3:D8, E3:E8, L3:L8

What would be the correct custom formula for this?


Bonus question: I would also like columns that contain only a question mark (so no x) to show up yellow, what would be the correct formula for this?

enter image description here

  • Welcome. Question should include only one question per post. Also it's recommended to include a brief description of your search/research efforts as is suggested on How to Ask. – Rubén Jul 6 '19 at 22:01
0
  • custom formula for range B3:O8

    =NOT(COUNTIF(B$3:B$8, "<>"))

    enter image description here


  • custom formula for range B3:O8

    =FIND("?",A$3&A$4&A$5&A$6&A$7&A$8)

    0

| improve this answer | |
  • Perfect, thank you so much! Do you also happen to know how to have the column show up yellow if there is only a question mark somewhere in the column? – Guest01 Jul 6 '19 at 18:31

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.