Conditional Formatting in a Data Table

[David Dickson]

I have created a table by keying in some row headings, some column headings and some data, then doing Home, Styles, Format as a table. Over the last few weeks I have added more rows and columns. I few days ago, I added some conditional formating to columns N, O and P. Then I added a few more rows and the CF was applied correctly to the new rows. I added a total row (Design, Table Style Options) and added a few more rows. Agin the CF was applied correctly to the new rows.

Yesterday I had 118 rows, then I added one new row. Today, I added another 5 rows, so I now have 124 rows. The CF was not applied automatically to these 6 new rows. I have had to apply it manually.

Does anybody have any idea why and / or how to fix it?

Thanks in anticipation.

David.