I have a spreadsheet with a macro to extract certain data. This document has various columns of dates that are conditionally formatted to turn red/yellow depending on how near the date is. The macro is intended to scan the sheet, and when it finds one of these red/yellow cells, extract certain information from the document.
It works overall....
If a cell is manually filled in using the toolbar, it works perfectly. But, if the cell is colored because of the conditional formatting (using the same colors), it does not.
Any Ideas? Any help would be greatly appreciated.