jb
Member
I have a table of data on my excel sheet named temp. I have applied conditional formatting on the table to highlight cells based on some criteria.
Now, when I move any cell value, rules for conditional formatting moves with data.
It is obvious. But I want conditional formatting to be applied on same location i.e. old location.
I found the solution that I should create a blank sheet with same table format and conditional formatting rules. And I should write a macro that will be executed when any cell value on temp sheet will be changed. This macro will copy format of table from new sheet and apply it on table on sheet temp.
I need such macro code. I have one additional requirement that manual formatting done on original table like underline or bold should be preserved.
Now, when I move any cell value, rules for conditional formatting moves with data.
It is obvious. But I want conditional formatting to be applied on same location i.e. old location.
I found the solution that I should create a blank sheet with same table format and conditional formatting rules. And I should write a macro that will be executed when any cell value on temp sheet will be changed. This macro will copy format of table from new sheet and apply it on table on sheet temp.
I need such macro code. I have one additional requirement that manual formatting done on original table like underline or bold should be preserved.
