Conditional Formatting for Values in 3 cells

[tvh]

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

 

[Peo Sjoblom]

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

 

[T. Valko]

Select the range of cells you want to format
Goto Format>Conditional Formatting
Formula Is: =COUNTIF($V$8:$X$8,">0")=3
Click the format button
Select the desired style(s)
OK out

 

[tvh]

thanks, folks....worked great!

Select the range of cells you want to format
Goto Format>Conditional Formatting
Formula Is: =COUNTIF($V$8:$X$8,">0")=3
Click the format button
Select the desired style(s)
OK out

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

thanks, folks....worked great!