If text is black then....

Hi I wonder if you can help,

I am creating a spreadsheet that once in full use will give subscription and redemption amounts for use in funding accounts.

I have written a couple of macro's for the spreadsheet already but there is one that is giving me a bit of bother.

Ideally I want to search all text in column D that is the colour black then move that data one cell right and two cells up.

Is this even possible?

Thank you

Hello & welcome to the board,

Here is a start, but need some information like what row do you start on. Example, if D2 has black text then how can it be moved up 2?

Please Login or Register  to view this content.

You're welcome

If you are satisfied with the response, please don't forget to mark the thread as solved.