Excel 2007 : Conditional Formatting issue concerning colors

Geoff84 Posts 2 Registration date Thursday January 15, 2015 Status Member Last seen January 15, 2015 - Jan 15, 2015 at 05:38 AM
 RayH - Jan 15, 2015 at 04:03 PM

I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell.

Does anyone have an idea how to do this?

Thanks in advance

1 response

What rule are you using to achieve what you have done so far?

What range are you applying the formatting to?
Surely you can just expand this range to cover what you need?

Make sure you are using $.
e.g. using the formula rule type

So when cell contains "x" the whole range applied gets the desired format.