Hi,
I was wondering if anyone could help me please with a problem i'm having in excel...

I am using 2003 and i have conditionally formatted all the way across my spreadsheet for the cell contents to go red if they are out of spec depending on the different bits of data. Each column represents a different characteristic, so each has different spec and different conditional formatting applied.

What I now need to do is write a macro to get the whole row to change colour (to red) if there is anything in that particular row that has been formatted to be red. Is this at all possible?

Thanks in advance for any help