matrix, conditional formatting and format painter issues

Ah, yes. I thought you want two identical tables.

If you will change the fields, definitely the conditional formatting will be gone.

Because when you are putting the conditional formatting, it is only intended for your selected field.

I have done also the same thing with you by putting the conditional formatting to several fields repeatedly.

Or, you may put up a formula using switch like this in a calculated column:

Switch = SWITCH(
            TRUE(), 
           Table Name[ColumnName1] = "CHEQUE", "#80e3e3",
            Table Name[ColumnName1] = "LC", "#45e997",
           Table Name[ColumnName2] = "100284", "#97e945",
           Table Name[ColumnName3] = 0, "#3e3e3e")

"#80e3e3" - this is a hex color that you will assign. Depends on what color you need.

then

On the conditional formatting, choose field value and the column you made:

for me I m using Last as summarization. You can also try First or depends on our needed result.

This is the workaround I know.

Hope this helps you.

You may suggest an idea or maybe others have a workaround for this.

Have a nice day.