conditional formatting -multiple conditions
Hi
I have a formula to change font colour based on condition of another cell.
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.
=ISNUMBER(SEARCH("No",G8))=TRUE
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
Hello KK1234,
It is possible with Conditional Formatting. If you could provide us with a sample WorkBook, we may be able to assist you.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Re: conditional formatting -multiple conditions
Cond Fromt.xlsm
Thanks . I have attached the file.
Thanks 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.
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
Re: conditional formatting -multiple conditions
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
Hello KK1234,
You are welcome.
Glad that I could help.
Thank you also for adding to my Reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
KK1234 
Register To Reply
Bookmarks