coloring in rows
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
|