Hi

Could somebody please help me with the following problem?

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

Thanks

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483715

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

Hope this helps
Rowan

koba wrote:
Hi

Could somebody please help me with the following problem?

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

Thanks

Andrew

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)


"koba" wrote in message
...

Hi

Could somebody please help me with the following problem?

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

Thanks

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile:
http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483715

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?

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483715

Sorry neither one of those formulas worked, same problem as before


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483715

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

koba wrote:
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?

Andrew

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


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483715

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

thats better thanks


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483715

You're welcome.

koba wrote:
thats better thanks