VBA to 'read' a cell's color?

[fourmurphys]

I have two tabs. Tab "A" contains data that is pasted during a macro. Tab "B" uses INDEX and MATCH formulae to return values from "A" because the row and columns vary week to week.

Here's the challenge.... The data in the cells in tab "A" will be either 'no fill', or green, or red. I would like for the corresponding linked-cell in "B" to also have the color of it's twin on "A"...

I'm told that absent a rule for the colors (there is none), that VBA would be my only hope... Help me Obi-Wan.

Thank you for any direction!

[shg]

If the cell color is applied manually on tab A, there's no way to make the color on tab B change automatically in response.

If it's changed by conditional formatting, use the same rule on tab B.

[fourmurphys]

shg... if not automatically, could it be done using VBA? Seems somewhere in the matrix there should be 'instructions' for coloring the cell in A, that could be read.....?

Holding out hope.....

Of course, as you have almost 36,000 posts... gonna guess that you know what you're talking about....

[shg]

There's nothing in Excel that would enable it to happen automatically as a result of changing a cell color.

You could test in the Calculate event (so it would check any time you change anything), but it could make the worksheet slow, and it would kill Undo -- which is a very high price to pay for a cosmetic effect.

[Andy Pope]

Assuming both sheets are not displayed at once you could use the sheet activate event to apply all changes whenever the user changes what sheet is active

[fourmurphys]

pasting a link below, that I came across... does this have any promise? I'm only using red and green, so maybe the color theme wouldn't matter?

http://stackoverflow.com/questions/2...get-cell-color