Hi,



The code I provided seems to work. If not tell me what part of the spreadsheet did not produce the desired out come.

Hi Charles

It only does the first lot of data for each venue, If you look at the attached file ( Report26022016 20-39 ) from todays output you will see that in Horse Racing Tab columns J : P only the one race has been color coded instead of all down the page J:P columns,
What I am trying to get is when the runners number or name appears in column D & E the sheet also color codes down the page the same as like columns B & C like it has done in column J2:P6 but none of the rest of J:P down the page till the next venue.
Venue is in Column A : Sunshine Coast 1 , Sunshine Coast 2 and so on the next venue starts A57 : Moonee Valley 1 , Moonee valley 2 and so on down the page
Sorry hopefully that makes sense

Cheers
David

Attached Files

Report26022016 20-39.xlsx (319.8 KB, 13 views)

Good Morning Charles
Did you receive the emailed Excel file
Just following up on your thoughts about the file.
David