Just wanting to see if anyone has ran into this problem in Excel 2007 yet. We have a large list of data with an autofilter on it. On column, R we want to show ONLY Blanks. Once we have the Blanks filtered, we put the word, TRADE (or any other word that you want). We finally select all the TRADE cell that were previously shown as blank and highlight them yellow. When we cancel the filter, all the rows in between are now highlighted yellow whereas in Excel 2003, only the rows that we highlighted when the filter was in place had the yellow highlighting.
There is a workaround that you can select each cell individually, apply a fill color, go onto the next cell, apply the color, etc but that is not efficient.
Any ideas?
Thanks!
There is a workaround that you can select each cell individually, apply a fill color, go onto the next cell, apply the color, etc but that is not efficient.
Any ideas?
Thanks!
