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
|