Thread: Change text colour if range of values all zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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.
Reply With QuoteReply With Quote