Conditional formatting w/ formula

[rjplante]

I have a three column table consisting of 40 rows. In column 1 will appear a number. I would like to have a border appear around the cells in column 2 and 3 if the value in column 1 is not blank. This is easy to do with conditional formatting.

The problem I am having is that when I generate the formula, it locks the cell position for the reference cell (eg. $B$10) and I would like to keep this relative so that when I grab the corner of the cell frame and right click and drag down to the bottom row to fill formatting only, the cell reference applies to each row and not linked to cell B10. Is this possible to do? or do I have to go and format each row manually?

Thanks

Robert

 

[Desu Nota from Columbus]

I have a three column table consisting of 40 rows. In column 1 will appear a number. I would like to have a border appear around the cells in column 2 and 3 if the value in column 1 is not blank. This is easy to do with conditional formatting.

The problem I am having is that when I generate the formula, it locks the cell position for the reference cell (eg. $B$10) and I would like to keep this relative so that when I grab the corner of the cell frame and right click and drag down to the bottom row to fill formatting only, the cell reference applies to each row and not linked to cell B10. Is this possible to do? or do I have to go and format each row manually?

Thanks

Robert

what is the formula you have tried?

say your table is setup in columns A-C, starting at row 1.

B1 conditional formatting should read: =B1=[insert your criteria here]

you should be able to drag this format down and the reference will change to the corresponding cells.

 

[rjplante]

I had merged cells and when I removed that I got it to work fine.