Hi,
I have a table with 3 evaluation scores per agent. It looks like this (see attached):
A1 - name of the agent
A2 - score 1; A3 - score 2; A4 - score 3
B1 - name of the agent
B2 - score 1; etc.
I would like to set a conditional formatting to highlight A2:A4 if all 3 cells in this range have a score (a.k.a. are not blank). If one or more of these cells is empty (no score yet), the range will not highlight.
I tried different formulas that I found online, but they didn't quite work:
=COUNTA(A2:A4)=3
=COUNTBLANK(A2:A4)=0
=SUMPRODUCT(--(A2:A4<>""))=3
- all 3 only filled A2 but not A3 and A4, although the cond. formatting should apply for =$A$2:$A$4
Apparently I am doing something wrong, but I just can't figure out what
Do you perhaps have any idea what I'm doing wrong?
Thanks a lot!
BTW Hello, I´m new here on this forum, so hope I don't make too many mistakes. If so, please do let me know. Thanks!
Kathi
Bookmarks