Excel spreadsheet/VBA question

I have a spreadsheet that I need to add some vba code to (My VBA is Okay but I can't figure this out).

In short the spreadsheet has text values in columns A:F Time values or Blank from G:M which are returned from a error/vlookup formula IE:
=iferror(vlookup,data,10,false),vlookup,data2,10,false)) in 4000+ rows

The columns G:M are coloured in various cells either "No fill" or red colorindex = 255 for arguments sake.

I need a vba module to run which will.
Highlight/change the colour index of any cells within this range that are "No Fill" colour but do hold a time value and ignore all other cells.

Thanks for any help in advance as all my previous efforts have failed and I running out of ideas