continuous conditional formatting

[bite_tony]

hi

I have a table inserted into my spread sheet,
I have various conditional formatting rules on it, which depending on whether there is a value (anything written) in a cell in a particular column will turn the whole row a particular colour..

e.g if there is a date in cell A3, then the whole of row 3 will turn green

I was under the understanding that as my information is in a table, every time a new row is added to the table it will apply my conditional formatting to that new row.
However, now, on row 258 of my table I am finding that is not the case

basically I need to know how to word my conditional formatting formula so that it is ongoing.
I don't want to predefine the area the formatting is applied to because the workbook is split into months (one worksheet=one month) and some months there might only be 100 rows of data, but another month there might be four hundred rows of data..

 

[Jerry Sullivan]

Hi bite_tony,

What version of Excel are you using?
What step(s) are you using to add rows to your table?

When I do what you describe with a table in xl2010, the conditional formatting is automatically applied to the added row.

 

[bite_tony]

hi..thanks for trying to get to the bottom of my problem..i fixed it now!! just thought I would update as to how, so that the thread can be solved..basically my formulas were locked into cells with dollar signs.. so my formula was in $G$2:$G$258 when all it needed was $G2 to keep applying the formatting to 'cell 2' in every row..