Thread: Change text colour if range of values all zero
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default 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.



Reply With QuoteReply With Quote