VBA Code For Conditional Formatting, cell that Contains...

[Darrellcoholic]

Hello,

I have a VBA code as followed and i will like to add on some VBA code which allows me to do conditional formatting of those cells that contains "No" and highlight it in red. I have tried but failed to write something that works. Can someone help me to this?

Please Login or Register  to view this content.

[adyteo]

try to embed this:

Please Login or Register  to view this content.

You need to replace "Your Range Here" with the range of cells where "No" would exist

[shopaholic]

Hi,

If you only wish to highlight cells containing "No" then you can use conditional formatting. That would be easier.

Anyway, this is a very basic code which you can tweak further to meet your requirement.

Please Login or Register  to view this content.

[Darrellcoholic]

Hi Adyteo,

Thank you so much. It works.

[Darrellcoholic]

Hi Shopaholic,

Thanks for that, will be useful for me