View Single Post
  #2   Report Post  
Rowan Drummond
 
Posts: n/a
Default 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