Highlight Inconsistent Formulas

As a followup to my post at http://www.excelforum.com/showthread...t=#post4450869, I'm now trying to color my Inconsistent formulas (those formulas flagged by Excel as being inconsistent with their surrounding formulas. The code I'm using is below, and my problem is down at the bottom, where I check for inconsistent formulas. I want to turn them RED, but for some reason my code is NOT coloring the cell, though I can see the green triangle indicating an inconsistent formula on the cell (see Instructions tab, F27). Any help would be appreciated.

Please Login or Register  to view this content.

Two things I see.

1. You appear to be looking at column A instead of F.
2. I think you need

Please Login or Register  to view this content.

The line

Please Login or Register  to view this content.

doesn't work.
I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Sorry, double post.

David,

Thanks so much for pointing out the A vs F, because that helped me spot an error in my methodology. The FORMULA resides on the "Instructions" tab, in Column F, and in the first part of my code I find that (and all other formulas) then list those on my "FormulaList" sheet, in column A. So my code is right to look in ColumnA, but wrong to look in ColumnA for the "inconsistent" part; that check should have been done in this section:

Please Login or Register  to view this content.

Okay, back to the drawing board for me. IF I can get back to it this week I'll post my corrected code (unless someone else wants to do that for me?????)

Sorry it took me so long to get back. I've solved the problem. Here's my updated code, and I've also attached a sample workbook for anyone who wants to see it in operation. The code is in the attachment, you'll just have to run the "Wkbook_ListFormulas" macro.

Please Login or Register  to view this content.

Hi there,

I tried using this code to highlight inconsistent formulas (yellow highlighted cells) in attached spreadsheet, but its not highlighting the same. Can anyone pls help.