View Single Post
  #8   Report Post  
Rowan Drummond
 
Posts: n/a
Default coloring in rows

Try this again:
Select Row 5.
FormatConditional FormattingDeleteCondition 1OK.
Now change the first Drop Down from "Cell Value is" to "Formula Is".
Then in the right hand box paste the formula:
=OR($L5="Bad",$N5="Bad",$M5="Bad")
Set your required formatting.

Regards
Rowan

koba wrote:
Hi Rowan

It colors in the whole row except for the cells inwhich i have text or
numbers

In the conditional funtion what did you make it. I put it under ëqual
to

Andrew