Select cells in excel based on background color

[bstrahan]

I am using conditional formatting to insert a background color into cells dependent on its relationship to another cell. Once this is done I want to "fix" the color so that it is no longer dependent on the conditional format, as the relationship cell changes. Is this possible either with VBA or a cell formula?

 

[SkipVought]

Hi,

This would need to be done with VBA code.

Please repost in Forum707

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}