conditional formatting -multiple conditions

[KK1234]

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

Please Login or Register  to view this content.

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

[Winon]

Hello KK1234,

It is possible with Conditional Formatting. If you could provide us with a sample WorkBook, we may be able to assist you.

[KK1234]

Cond Fromt.xlsm

Thanks . I have attached the file.

[KK1234]

Thanks Winon.

[Winon]

Hello KK1234,

Check out the attached Workbook.

Is that what you want?

Also see the "Please consider" note at the bottom of this post.

[KK1234]

Hi Winon,
Perfect solution.
Really appreciate.
I started learning few months ago , still floating on the surface & vast deep ocean of knowledge to learn.
But where there is will , there will be a way.
Thanks again for your help.
I have also clicked * for you.
Well done my friend
Regards

[KK1234]

Hi Winon,
Perfect solution.
Really appreciate.
I started learning few months ago , still floating on the surface & vast deep ocean of knowledge to learn.
But where there is will , there will be a way.
Thanks again for your help.
I have also clicked * for you.
Well done my friend
Regards

[Winon]

Hello KK1234,

You are welcome.

Glad that I could help.

Thank you also for adding to my Reputation.