auto fill color of row
 

I have conditional formating & color in a cell, but I want to color the
entire row of conditional formating cell. Is there any option to do it ?

auto fill color of row
 

Hi,

You could use the formula is option in your conditional format..

Maybe..

Select your row and use this conditional format..

In the example below I have selected a range of cells.

Formula isEqual to=A1=1

This will change the format of my selected row if cell A1 = 1...

Hope this helps,

Gav


"capital letter" wrote:

I have conditional formating & color in a cell, but I want to color the
entire row of conditional formating cell. Is there any option to do it ?

auto fill color of row
 

I guess that Gav may have intended to say =$A1=1, as the absolute addressing
ensures that the A1 formula is applied to all the selected cells. If you
select the range and insert the formula using A1 instead of $A1, then it
would look for B1 being 1 to shade cell B1, and so on, instead of shading
all of them if A1=1, which is what I thought was required?
--
David Biddulph

"Gav123" wrote in message
...
Hi,

You could use the formula is option in your conditional format..

Maybe..

Select your row and use this conditional format..

In the example below I have selected a range of cells.

Formula isEqual to=A1=1

This will change the format of my selected row if cell A1 = 1...

Hope this helps,

Gav


"capital letter" wrote:

I have conditional formating & color in a cell, but I want to color the
entire row of conditional formating cell. Is there any option to do it ?

auto fill color of row
 

David,

Thanks for pointing that out it was a small typo on my part..

Gav.

"David Biddulph" wrote:

I guess that Gav may have intended to say =$A1=1, as the absolute addressing
ensures that the A1 formula is applied to all the selected cells. If you
select the range and insert the formula using A1 instead of $A1, then it
would look for B1 being 1 to shade cell B1, and so on, instead of shading
all of them if A1=1, which is what I thought was required?
--
David Biddulph

"Gav123" wrote in message
...
Hi,

You could use the formula is option in your conditional format..

Maybe..

Select your row and use this conditional format..

In the example below I have selected a range of cells.

Formula isEqual to=A1=1

This will change the format of my selected row if cell A1 = 1...

Hope this helps,

Gav


"capital letter" wrote:

I have conditional formating & color in a cell, but I want to color the
entire row of conditional formating cell. Is there any option to do it ?