coloring in rows

K

koba

Hi

Could somebody please help me with the following problem?

How do I set a conditional format that if L5,M5, or N5 = “BAD” the
highlight the row yellow, otherwise leave it the standard non fil
color (clear)

Thanks

Andre
 
R

Rowan Drummond

Select Row 5. Format> Conditional Formatting. Formula is:
=OR($L5="Bad",$N5="Bad",$M5="Bad")
Set the required colour format,

Hope this helps
Rowan
 
B

Bob Phillips

Select the row, and in CF use a formula of =COUNTIF($L$5:$N$5,"BAD")>0, and
in the pattern tab choose your colour.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
K

koba

Thanks

The formula works but its NQR

It only colors in rows that do not have text in them not the whole row
Can you think why this would be?

Andre
 
R

Rowan Drummond

It works for me. How did you implement it? Did you mean only colours in
CELLS that do not have text in them and not whole row?

Regards
Rowan
 
K

koba

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
 
R

Rowan Drummond

Try this again:
Select Row 5.
Format>Conditional Formatting>Delete>Condition 1>OK.
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
 
Top