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.

 

[Patriot2879]

Hi sorry about that, yes I did do exactly, the yes and no works but not the 2 man I did do - =LEFT($B2,5)="2 man ladder"

 

[Patriot2879]

Hi please see below my new link to dropbox, with the new codes added.
https://www.dropbox.com/s/6n9y31sgai0mqli/Half%20Hourlynew.xlsm?dl=0

 

[Fluff]

Change the B2 formula to what I showed in post#6

 

[Patriot2879]

Hiya that works thank you for you help on this, where did I go wrong if you can please advise?

 

[Fluff]

You changed the formula.
=LEFT($B2,5) looks at the first 5 characters in B2, you were then comparing that to "2 man ladder" which is more than 5 characters so it would never match.

 

[Patriot2879]

ahh ok thank you so much shall remember that

 

[Fluff]

You're welcome & thanks for the feedback

 

[Patriot2879]

Hiya all, I am trying to do another conditional for another word 'Escalation' and trying to follow the process already given to me, but I cant seem to get it to work, please can you help, this is the process I have followed for the word 'Escalation' in Row B.
=LEFT($B2,5)="Escal"

I have got this working now as I had to many letters, but my yes and no is not changing color now I have added this other code.
I have added the file to dropbox if you can please help.
https://www.dropbox.com/s/36544cqmbgdu92e/hh.xlsm?dl=0

 

[Fluff]

My guess is that the rules are in the wrong order.
If you want the Yes/No to over-rules the other formatting they need to be the first 2 rules in the list.

 

[Patriot2879]

great sorted now thank you