Conditonal formating in a Table: Highlighting current row and cell

[inddon]

Hello There,

I have a conditional format to show current row as highlighted. But the highlighting doesn't work properly. For eg. when I extend the columns in the table, the highlighting does not work for those extended columns ( K to M).

Attached is the file for your reference. Could you please advise?

Regards
Don

 

[NARAYANK991]

Hi Don ,

The CF rules are not working for the added columns because the Applies To range for the CF rules has not automatically been changed to include the added columns ; I am not sure there is a solution to this , except that you manually include them.

In your case , the Applies To range is :

=$C$5:$J$13

Changing the above to :

=$C$5:$M$13

will extend the CF rules to the added columns.

Excel converts even a dynamic named range reference to a static reference in the Applies To box.

Narayan

 

[inddon]

Hi Don ,

The CF rules are not working for the added columns because the Applies To range for the CF rules has not automatically been changed to include the added columns ; I am not sure there is a solution to this , except that you manually include them.

In your case , the Applies To range is :

=$C$5:$J$13

Changing the above to :

=$C$5:$M$13

will extend the CF rules to the added columns.

Excel converts even a dynamic named range reference to a static reference in the Applies To box.

Narayan

Thanks Narayan for your reply.

Just a thought:
Is there a VBA procedure that fires when you extend rows and columns?
If it is there, then this can be dynamically done.


Regards
Don