Change text colour if range of values all zero
 

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.

Change text colour if range of values all zero
 

Select A2, then apply conditional formatting using Formula Is:
=COUNTIF($E2:$L2,"0")=8
Format the font color: red
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robin" wrote:
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.

Change text colour if range of values all zero
 

Hi Robin

FormatConditional FormattingFormula is
=COUNTIF(E2:L2,"=0")=8
Set Format to Font Red.
--
Regards
Roger Govier



"Robin" wrote in message
...
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.

Change text colour if range of values all zero
 

Roger & Max -

You don't need the quotes

=COUNTIF(E2:L2,0)=8

works equally well


"Roger Govier" wrote:

Hi Robin

FormatConditional FormattingFormula is
=COUNTIF(E2:L2,"=0")=8
Set Format to Font Red.
--
Regards
Roger Govier



"Robin" wrote in message
...
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.

Change text colour if range of values all zero
 

Agreed, Duke. Thanks. For me, maybe it's a diehard subconscious habit to
generalize it to handle text as well, besides numbers <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Change text colour if range of values all zero
 

Thanks everyone. Its most appreciated.

Robin

"Max" wrote:

Agreed, Duke. Thanks. For me, maybe it's a diehard subconscious habit to
generalize it to handle text as well, besides numbers <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---