Hello,
I've come across a unique (to me) problem, we had a consultant in and they created a spread sheet. We now want to sort on some values, and ....lo and behold...the consultant color coded some cells but placed no values inside of them....and those are the cells we want to sort on. We have other cells that are totally blank by design on the spreadsheet, so I can't do a bulk replace of all empty cells, I need to somehow read the color of a cell and change the value.
I'd rather not do it manually, anyone have any suggestions?
Bookmarks