Hi all,

I've searched all over the net for this one since I thought it would be a popular question, but unfortunately couldn't find a solution.

Would anyone know how to (using VBA only) perform a VBA "conditional format" so that every cell in col R, that contains the word "YES" will have a green background?

...ps: This needs to be done via VBA only since I need to run the code from a personal.xlsb file.

Thanks so much,
JMC