Conditional Formatting in Excel Table - new row problem

[GreenBoy]

Hi

I am sure if there is a solution to this, its probably very simple, but at this time, I cannot figure it out.

I have a table in a worksheet which I have added some Conditional Formatting, to change whole rows a different colour if a certain value is entered in the first column. I need this condition to apply to the whole table including any new rows when created. As it stands when I create a new row, either by Tab'ing from the end of the last row or by starting to type in the cells immediately below the table, the new Table row is created, but the conditional formatting is not present. I have to select the whole row above and format paint to the new row to get the conditional formatting to work.

Is there a way to make Excel apply the conditional formatting to new rows by default?

Thanks in advance.
GreenBoy

[6StringJazzer]

I would set up your conditional formatting rule to apply to a range that includes the maximum number of row you might possibly use, rather than the number of rows actually in the table.

[TMS]

If it's a Structured Table, it should automatically apply the CF rules.

See attached example.

If this does not help, please upload a sample workbook.