VBA and Conditional Formatting to fill cells with X colour if they contain a comment

What I'm trying to do is colour / fill a cell with a colour if that cell has a comment.

I'm taking inspiration from this post here:

<I'm not allowed to post links until I post few times>


What I'm trying is insert this code into vba

Function IsComm(CellComm As Range) As Boolean
Application.Volatile
IsComm = False
If Not CellComm.Comment Is Nothing Then IsComm = True
End Function

So what I've done is:

1. hit ALT+F11
2. right-click in the VBA project window
3. click insert module
4. copy and paste the code above
5. and then click save and save the excel worksheet with macros enabled

I then add conditional formating logic by:

1. clicking home
2. clicking conditional formating
3. clicking new rule
4. use formula to determine which cells to format
5. type exactly this "=IsComm(A1)" without quotes in the "format value where this formula is true" box.
6. select the colour green from the format button and fill tab.

below are some pictures of me suffering: