Macro Not Reading Conditional Formatting

Hello All,

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.

you cannot use the Interior property of the range to read conditional formatting. fortunately you are using excel 2010 and have access to the new Displayformat object. use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

in your code