Making .find command compatible with Excel 2011 (Mac)

I am sure there is a very simple solution to this problem but I have had no luck in finding an answer.

Essentially, I have a macro that performs a .find function on a sheet and loops through all the cells on that sheet. An example is shown below;

Please Login or Register  to view this content.

My problem is as follows. In my windows version of excel (Excel 2013) it works flawlessly. When used with a Mac version (Excel 2011) the code does not return the values from the .find command and returns the interior color as black rather than the color that it should actually find and identify.

As far as I can see, this part of the code in my workbook seems to be the only one deciding not to work so I assume that the .find command must work somewhat differently in Excel 2011.

The only thing I have done that may have an impact here is I have disabled the 'Microsoft VBScript Regular Expressions 5.5' reference through the VBE as when the workbook is opened in Excel 2011 it is listed as 'Missing' which was causing my code to error.

This wouldn't bother me too much if I hadn't spent my whole Easter weekend building a workbook for a friend who owns a Mac. So now I just need to iron out this last crease to complete my work.

Thanks in advance.

That was what I was afraid of. Seems like such an important feature to be omitted. Pardon my ignorance, but surely there is some alternative in Excel 2011 to the find argument.

I have attached a sample workbook that shows you what I am trying to achieve (and why I have the find argument running three times).

If anyone could assist on an alternative to what I am trying to do here I would really appreciate it.

Dummy Workbook.xlsm

It is all running smoothly now.

Thanks for your help JosephP. Very much appreciated.