Hello,
If we have a table with a column of values that have a conditional formatting relative to those values (e.g. red cell for the highest value of the column, green cell for the lowest), and then we filter this list so one of these values is filtered (hidden), the conditional formatting still...
Hi all,
I have no problem when it comes to create a pivot table using data from a single sheet that includes, say, columns Date+Category+Amount; so I can easily get for example a summary pivot table with dates by month on one axis, categories on the other, and sum of the amount on the body...