Conditional Format not apply to entire table

Question

Hi all, 

I have set a conditional format and would like it applied to the entire table. It doesn't want to apply to any new rows without a format paint done. Not sure how to tell the conditional formatting to apply to a table rather than a range of data?

There are several columns that have conditional formatting, I've attached a screenshot of one instance along with what the conditional format rules manager looks like. I don't know VB, but use the GUI to set these conditional formats. In the below screenshot I've just inserted a new row by tabbing from the last cell in the table, and you'll see the formatting doesn't apply automatically.

I was looking for a way to name the table and apply each rule to the table name rather than a range. But I could be wrong too :-(. Any help would be appreciated.

Thanks in advance for your help. Always appreciated!

Christine

Answer 1

Hi,

Conditional formatting is not working on the last row because that tis being treated as a Total row.  Click on any cell in the Table and go to Table Tools > Design.  Uncheck the Total row checkbox there.  Now right click the any cell in the last row and delete that row.  When you now add a new row, conditional formatting will work as expected.

Here's a screenshot

Answer 2

Thanks so much for the help.

Column G

If set to "Not yet confirmed" change text to blue.

If set to "Confirmed" change text to green.

If set to "Cancelled" change text to red.

Column H

If set to "N/A" or "Internal Not Scheduled" change text to blue.

If set to "Cancelled" change text to red.

If set to "Internal Scheduled" or "Scheduled" change text to green.

If it's too many parameters, I could simplify by leaving "Not yet confirmed, N/A, and Internal Not Scheduled" as black with no color change.

Thanks again,

Christine

Answer 3

Hi Christine,

That looks feasible, as it now over 7 PM overhere, time to stop but I'll give it a try tomorrow.

Answer 4

Thank you, enjoy your evening!