Making code recognise conditional formatting

**craigten** · 05-06-2013, 07:21 PM

Hello
I have just recently been helped with code to transfer rows of information with red font (a date in column D) to a target sheet (same workbook) by a very helpful member here. It works great when i change the font manually.
However, after using conditional formatting to change the cells to a red font the code doesnt recognise it and no information gets transferred to the target sheet. (thought id give my previous expert assistant a break

)

Any suggestions

Thanks

The code i am using:

Please Login or Register  to view this content.

**JBeaucaire** · 05-06-2013, 07:35 PM

You can't really do that, detect the "RESULTS" of a conditional formatting rule on a cell. Only the applied properties of the cells are exposed to VBA for testing. But you shouldn't do it that way even if you could.

A rule of thumb for you needs to be Color is not data. Coloring is something you apply to a cell to draw human attention. For Excel, you simply have to teach your VBA the same logic you put in your CF rules and have VBA do the same tests in another way.

For instance, perhaps your rule colors all the cells in column F "red" that have the word "Yes" or "Complete" in them. You could have VBA apply and autofilter to that same column to show only the YES/COMPLETE cells in that column, then "do your stuff" on the remaining visible rows.

So, in short, whatever logic you used to make the cells red, tell Excel THAT logic and it can do the same thing for you, color irrelevant.