Color cells which has comments

Hi ,
I need to color those cells which has comments in worksheet.
If the comments are added to few cells, those cells has to be colored & like wise if i remove the comments from cells, the color has to be removed.

How can I get this resolved.

Any response will be highly appreciated.

Thanks in advance
Rakesh

Rakesh,

domincb answered this question, but it was 4 years ago; the summary is, conditional formatting with a VBA rule.