I see that I can test for and find the Color Index of a cell by using the following VBA code:
But, the above code will not return the visible Color Index code of a cell that has Conditional Formatting where the rules of the Conditional Formatting has changed the Color to something else.
So, if the cell in question has been set to have the Color Green (Index=65280), but a Conditional Format rule has changed the cell color to Red(Index=255), then the above code returns the originally hard set color of Green-65280, but not Red-255, which is what the user sees when looking at the cell.
How can I find through VBA what the CondForm'd Color has been set to?
VBA Code:
colorCode = Range("S4").Interior.Color
But, the above code will not return the visible Color Index code of a cell that has Conditional Formatting where the rules of the Conditional Formatting has changed the Color to something else.
So, if the cell in question has been set to have the Color Green (Index=65280), but a Conditional Format rule has changed the cell color to Red(Index=255), then the above code returns the originally hard set color of Green-65280, but not Red-255, which is what the user sees when looking at the cell.
How can I find through VBA what the CondForm'd Color has been set to?