conditional formatting using macro for excel 2003

[kgvic]

Hi all,
another request for my works spreadsheet....I have data in columns A-R over multiple rows (integers, text and dates).
Column F contains several drop down items (data validation from another sheet).
I need the text of columns A-Q, in the appropriate row, to be blue if any option containing the word 'industry' is selected in column F (there are several industry options but all START with the word 'industry').
I know excel 2010 allows this to be done with conditional formatting, but this doesn't work on 2003 versions. I suspect a macro is required, but can't find anything that fits.

Again, I am unable to upload right now due to network restrictions at work...I will upload tonight at home.

Any help in the interim would be much appreciated.

Regards,

Steve.

[ragulduy]

high light columns A-Q and with A1 active set the conditional format formula to:
=isnumber(find("industry",$F3))

Edit: that would just be for containing, for starting with you would need to add =1:
=isnumber(find("industry",$F3))=1

[kgvic]

Thanks for the answer, but i can't get this to work. Any other ideas please?

[ragulduy]

Hi,

Please find attached an example workbook with the conditional formatting implemented.

[kgvic]

I looked at the sheet you attached, which worked a treat....however, copying that formula into mine didn't work!
Will that type of conditional formatting work on excel 2003? I did have it working on 2010, but it failed on 2003.
Please find my spreadsheet attached.....don't pay too much attention to the macro coding...it's probably very messy, but it works! lol

Steves tracker.xls

Many thanks,

Steve.