Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic.
Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to create for that?
Same with making informational rows or summary rows at the start of a sheet, show me how then to deal with sorting of the column later - what happens?
Where is this type of information?