Excel 2007 : Conditional Formatting issue concerning colors

Closed
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
Dears,

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
Geoffrey

1 reply

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
=$A$9="x"

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