Hi Mr Excelians,
I have some conditional formatting in a list object (table). They are almost 6 or 7 conditional expression based formatting.
Each time I am adding or deleting any rows to/from the table, these conditions duplicated and their area changes. I want a way to have a neat and clean conditional formatting.
I am wondering is there any way to reapply these formatting to that range "Table" after any change that made them messy, or any other solution for such a problem? I think it may fix my problem. I read the Microsoft MSDN help, It seems that only three conditions can be set out with VBA.
Any Idea or solution for help?
Thanks
here is a snapshot of my file.
I have some conditional formatting in a list object (table). They are almost 6 or 7 conditional expression based formatting.
Each time I am adding or deleting any rows to/from the table, these conditions duplicated and their area changes. I want a way to have a neat and clean conditional formatting.
I am wondering is there any way to reapply these formatting to that range "Table" after any change that made them messy, or any other solution for such a problem? I think it may fix my problem. I read the Microsoft MSDN help, It seems that only three conditions can be set out with VBA.
Any Idea or solution for help?
Thanks
here is a snapshot of my file.

Last edited: