Cell-Color searching function

[jrodri14]

Hi!

I'm looking for any possibility of a function that can start of from a particular cell, and move up until it hits a cell with a certain color. Then, I simply want it to output the name of that cell.

Is that possible?

[pike]

jrodri14
maybe..in a kinda roundabout fashion

Please Login or Register  to view this content.

[pike]

also three is the colour red

[foxguy]

jrodri14
maybe..in a kinda roundabout fashion

Please Login or Register  to view this content.

I think he wants cell color, not font color.
If so change to

Please Login or Register  to view this content.

[jrodri14]

So, I guess there is no way to ask it to start off from a particular cell, and look for the first cell above it with that particular color?

[justinvalle]

I think I get what you want, here's my solution.

Please Login or Register  to view this content.

[foxguy]

So, I guess there is no way to ask it to start off from a particular cell, and look for the first cell above it with that particular color?

This sub will find the 1st cell above the current selection with the same cell color as the selection. Or if you know the ColorIndex that you want to locate, call it with the ColorIndex you want
Didn't test it, so let me know if it doesn't work right.
Edited to put in calling from different selection.

Please Login or Register  to view this content.