Change text colour if range of values all zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

If all the values in cells E2:L2 = zero then change the font colour of cell
A2 to Red.

How do I achieve this please?

Thank you.
 
Select A2, then apply conditional formatting using Formula Is:
=COUNTIF($E2:$L2,"0")=8
Format the font color: red
 
Hi Robin

Format>Conditional Formatting>Formula is>
=COUNTIF(E2:L2,"=0")=8
Set Format to Font Red.
 
Agreed, Duke. Thanks. For me, maybe it's a diehard subconscious habit to
generalize it to handle text as well, besides numbers <g>.

---
 
Back
Top