Dear Sir / Madam,

I need help on a formula or anything which i have this cell when i click on
the drop down list of containing "pending" & "closed".

I select "pending" from the drop down list and the cell next to it,
background turns to "red" colour.

When i select "closed" from the drop down list and the cell next to it,
background turns to "yellow" colour.

Please advise how could i do this?

Thank You!
Warmest Regards,
Kelly