Get Displayed Cell Color (whether from Conditional Formatting or not)

[jamilm]

Ok Mr. Administrator. roger that.

cheers,

[deanmosh]

Thank you for writing this code—it is exactly what i needed and will likely save me hours of work. as a complete novice at this sort of thing i've tried to implement this code but have had no success at getting it to work.

is it as simple as copy and pasting the code into a vba module? would someone be able to write a step by step intended for a true beginner at this stuff? i've been a lurker on this forum for a while and have gleaned so much helpful info, but signed up as this is the first time i've tried to use code and have not been able to get an answer.

thanks in advance to anyone who can help me out—it would really be appreciated.