How to make row change colour based on text colour in row?

**Joanna13** · 09-02-2010, 06:52 AM

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

**teylyn** · 09-02-2010, 06:59 AM

Joanna,

you can use conditional formatting for the whole row.

If you have ConditionA to format cell A1, ConditionB to format cell B1 and ConditionC to format cell C1, then you can use a combination of these conditions to format the whole row.

Highlight the row, then use a formula along the lines of

=OR(ConditionA, ConditionB, ConditionC)

It will be easier to work this out with you if you can post a sample file that represents your data structure, a few conditionally formatted cells and a manually mocked up row with the expected formatting.

cheers,

**Joanna13** · 09-02-2010, 09:25 AM

I'm not sure how that will work as there are 41 different conditions, one for each column, going across the page... some are if not between, some if greater than, some if less than. would it still work like that?

I've tried highlighting the row, and using conditional formatting, but cant seem to make it work by typing conditiona etc in.

Sorry to be a pain, i'd tried writing it as a macro, but my VBA skills are limited as not done it properly in years.

Thanks!

**teylyn** · 09-02-2010, 04:39 PM

Please post a sample spreadsheet, as there may be other ways of achieving this, but, as already said above, this will be easier when we can see your file. The same goes for VBA suggestions.