How to find colored text

Hi,

how to find the blue text in all sheets? I have around 10 sheets and from each sheet if a cell contains text in blue then that row, row number and the sheet name should be captured in a new sheet. Could you please help me do that?

Thanks

Hi,

One way. Create a new sheet called "Colours", add the following VBA procedure and run the macro. Just check that colour index 5 is the blue colour you're looking for. if not just alter that line in the procedure.

Please Login or Register  to view this content.

Thanks for the help - However, it seems like it is not working for me. I tried adding a new sheet with the name as "Colours" then I executed the macro but the code didnt work. any more suggestions or tips would be of great help - Thanks!!!!!!!!

Hi,

When you say it's not working, what happens? Do you mean the macro falls over, or you don't get any results listed on the "Colours" sheet.

Have you checked that you have cells coloured with a background colour index of '5', or are your 'blue' cells a slightly different shade of blue with a different colour index to 5?

HTH

Are the font colors due to conditional formatting? It makes a big difference.

Hi,

I now see my mistake. I had misread your original and thought you were talking about the cell background. I now realise you meant the font colour.

In which case please change this line:

Please Login or Register  to view this content.

Rgds

Hi,

Have you tried stepping through the macro to see why it is not entering the IF..THEN..END IF test?

Try colouring the font in A1 on sheet1 and observing why it fails the test.

Otherwise upload the workbook and I'll take a look.

Rgds

With a slight tweak, you can use Richard's code. When you add the extra condtions, extra code will be needed.

First, get the Blue check to work using Richard's code:

Please Login or Register  to view this content.

Well, I am completely naive in this coding. However I managed this code and it is partially working. the below code doesnt print the row data where the text is in blue and when the cell has multiple colors its failing. Could you please help me fix this? - Thanks

Please Login or Register  to view this content.