Log In
Register
Home
New Member
November 26, 2024
Offline
Hello everyone around the world,
Here is a table with fictitious sales figures of 6 stores; 3 in the Netherlands and 3 in Belgium. They sell only 3 types of items.
I have applied conditional formatting to the rows with a subtotal. But now when I add a Store or change the name of a Store, the conditional formatting is not automatically applied.
I expect the same problem with PivotBy.
According to everything I've read, (and you also mentioned it in your video) it should. Does anyone know why this problem occurs and what the solution is?
I also tried to solve it with Named Range or hash (#). I couldn't manage that or Conditional Formatting doesn't accept that.
FYI
I am working with the Dutch region settings. The separator for arguments is a semicolon and not a comma. Index numbers between curly braces (for example, in Sorting) we write as follows in Dutch: {2\3}.
I would prefer to solve it without a macro.
Many thanks then for thinking with me!
Kind Regards, Willem from the Netherlands
Moderators
January 31, 2022
Online
I believe you missed one short sentence in the video that isn't included in the text script. At about 3:42 into the video, Mynda says: "By the way, if you expect the table to grow then select more rows or columns here."
But then you also need to change the Sub-total rule so that L="" AND K<>"". Otherwise the empty rows in the larger range will become green as well.
And, by the way, for the Grand Total format to work as intended, move it up and set it to 'stop if true'.
See attached.
New Member
November 26, 2024
Offline
Hi Riny,
Indeed, I think I missed that short sentence. It was also that short. 🙂
I don't need to put any more energy into this now either.
It does surprise me that Microsoft doesn't fix this kind of things. Besides the great advantages of working with DA, this is an irritating disadvantage. Maybe I should create macros for this.
Thank you very much!
Regards,
Willem
1 Guest(s)
