Forum Discussion
#Spill functions: dynamic data, dynamic tables, but no dynamic formatting? Is this acceptable?
I have a complex worksheet than can fetch several hundred lines of data using 4 database queries. The help the user summarize and work through it interactively, I am working on an interactive das...
Yes, and I would also like to be able to apply conditional formatting to a dynamic range. My normal technique for propagating a format is to click format painter with the anchor cell selected and then press Ctrl/Shift/Arrow, but that only goes as far as the current range. Another option is to apply the formatting all the way to the bottom of the sheet (don't stop short because that will mess up the used range).
If this is of immediate importance to you, Charles Williams FastExcel has the issue covered, including a floating totals row.