Conditional Formatting - Format row based on cell value in specific column

Hi,

Try this code in the worksheet module (this will replace your current Worksheet_Change event):

Please Login or Register  to view this content.

Hope this helps

Awesome! Thank you ajryan88. Works like a charm

No problems.

Please don't forget to mark this thread as solved and please click on the * next to my post to say thanks

Hey ajryan88,

How difficult would it be to add another condition to this code? We now need 2 conditional formats. Yellow if status = "Open" (which we already did), or, if the title (column F) = "Audit NC" AND status = "Open" fill green...

I have had a wee play with it, but to no effect as yet. (It's not crapping out, but it's not working either!)

Can anyone else help me with this?

How difficult would it be to add another condition to this code? We now need 2 conditional formats. Yellow if status = "Open" (which we already did), or, if the title (column F) = "Audit NC" AND status = "Open" fill green...

Hi Kite3,
maybe so

Please Login or Register  to view this content.

Hey Nilem, thanks for the code. It's not working though. Still goes yellow but not doing the green. Have attached a copy of the s/s.

New Walkthroughs 3.xlsm

Kite, remove all conditional formatting rules in your file to see the green fill.