Excel spreadsheet/VBA question

Closed
as400baz
Posts
1
Registration date
Wednesday May 25, 2016
Status
Member
Last seen
May 25, 2016
- May 25, 2016 at 11:56 AM
 Blocked Profile - May 25, 2016 at 04:45 PM
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

1 reply

Blocked Profile
May 25, 2016 at 04:45 PM
Don't use VBA, use the built in Conditional Formatting. What version are you using?
0