Conditional Formatting for Values in 3 cells
Select the range of cells you want to format
Goto FormatConditional Formatting
Formula Is: =COUNTIF($V$8:$X$8,"0")=3
Click the format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
"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
|