Hi
I have a formula to change font colour based on condition of another cell.

=ISNUMBER(SEARCH("No",G8))=TRUE
However I am trying to achieve is if value in cell G8 is 'No', then in cell G10 ( having drop down list say a,b,c,d) changes colour if word 'c' is selected.
If any other word like a,b,d selected then font colour will not change.
Is it possible to incorporate in formula?

Or

do I need a VBA code?

Regards