Forum Discussion
Filter Formula
I am trying to use the Filter formula to return the data from cells that are colored red from one sheet to another. Does anybody know the best way to write the formula to base the search strictly by...
Formulae don't work with cell properties like colour, only with values. If you have some logic why this or or that colour was applied, you may use it in formula. Otherwise VBA.
This is for our company's bank reconciliation. We have 43 locations. I need to collect all the cash, check, and credit card sales that are deemed deposits in transit by highlighting them red on their individual tabs in one spreadsheet. Once they are highlighted red, I need to have all of them listed together for other month end reporting. Any ideas how I can do this? I appreciate any help you can offer.