View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Conditional Formatting for Values in 3 cells

Try formula is and

=COUNTIF($V$8:$X$8,"0")=3

I assume you know that you need to highlight the whole row you want to
format
It's important with the absolute references

--


Regards,


Peo Sjoblom





"tvh" wrote in message
...
I apologize for taking up your time, but I did search before asking.

I need to highlight a row if three particular cells in the row (V8, W8 and
X8) all contain a value greater than 0. I tried several different
formulae,
but no luck.

Thanks