Highlight Rows in Different Color Based on Multiple ConditionsHighlight Rows in Different Color Based on Multiple Conditions

[Patriot2879]

Hi goodmorning, I hope you can help, I have tried conditional formatting but it doesn’twork in the way I want it to, I hope you can help me with the vba code for it.
I have row Nthat if ‘Yes’ or ‘No’ is highlighted from a list then I want the column to begreen if yes and red if no.
Then in RowB if ‘2 man ladder’, ‘2 man other’ or 2 man no parking’ is shown from the list I want the column tobe a light blue colour.
I hope youcan help me please. There are other rowsand columns I need adding as well, but these are some for examples.

I reallyhope you can help me please with this.

 

[Fluff]

My pleasure & thanks for the feedback

 

[Patriot2879]

Hiya Fluff please can you advise how to I make the whole line 'yellow' if anything is entered into Row J2 I have tried :
=$J2="*"
but this didnt work

 

[Fluff]

Try
=$J2<>""

 

[Patriot2879]

that works great ty

 

[Fluff]

You're welcome