auto fill color of row

C

capital letter

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 ?
 
G

Gav123

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 is>Equal to>=A1=1

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

Hope this helps,

Gav
 
D

David Biddulph

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?
 
Top