Consolidating / Extracting Conditionally Formatted (Colored) Cells - Excel 2003

I am attaching a worksheet where columns B and C contain conditionally formatted rows. Basically, both columns have data that try to match each other. Column B tries to match itself with Column C. If a match is found, the font color remain black. However, if no match is found, the font color of the cell turns red (based on a conditional format formula).

What I have been trying to do for the past 3 days is trying extract only the red cells. I know Excel 2007+ has a conditional sort / filter feature.........but I only have 2003 to work with. I found some VBA code but that only worked if I manually colored the cell (not conditionally).

If I could get only the red cells to appear in columns E & F (respectively)....that would work great, since then I could just set the print area and print these red cells (instead of manually trying to write down each red cell value on paper).

Thank you in advance. I only signed up after searching for days to this solution.

Okay.....I made some headway. I tried your modified formula and I have partial success. Now in columns E & F, only the conditional colored values show up (which is exactly what I was looking for). However, the values appear in their respective rows (meaning that if i have data in B4:B200 ....... the values in E4:E200 are scattered throughout the range).

Is there a way to make them appear consecutively from E4 down (without any blank cells in between). I tried filtering.....but that affects my rows in columns A, B, C, ).

Thanks very much for your help.

Hi,

I added the extra 2 helper columns but I found an issue when I added the formula to cell E4.
If I make the range down to G635, it picks up cell G36 (52). But if make the range to G634, it skips G36 and goes to the next big value. (sheet attached)

Another problem is that data in columns A, B, C, will always be changing (filling up 100 rows to sometimes 1200 rows) and the SMALL function has to be edited each time.

Columns G & H are perfect.....because now they change automatically with what I insert into columns A, B, C.

Thanks again.

Okay I tried that and Yes that works. I am 99% there. My issue is that I edited the "SMALL" code to start from row 4 (my first row that will have data) all they way down to row 1500 (the maximum rows I will ever have).

But now if I only have data in 100 rows, the SMALL function returns "0" in E4 thru E800, and then starts listing the cell values in order.

However, if I modify the SMALL function and limit it to the number of rows I actually have data in (column A B & C), it works fine. But to keep doing that defeats my purpose.

Thanks again. Especially for the quick replies. Are you in front of a PC all day long?

Update: I just wanted to FDibbins for all your help. I have my sheet just the way I wanted it I will now mark this thread solved.