Conditional Formatting not updating on paste values

[farnuckl]

I swear I've seen something addressing this in the past, but haven't been able to find it...

I have some conditional formatting to color cells that contain a certain value. I "paste values" into the range to update any changes in the list. The problem is the conditional formatting doesn't kick in when I copy the list in. I have to double-click on the cell to get it to apply the formatting. There must be an easier way to handle this either through VBA or formatting.

Thanks,
Farnuckl

 

[RalphA]

Since you have not had a response, I will put in my two-cents worth... I don't know wha may cause your problem, but, I have seen similar problems reported with formulas. Sometimes, the cure has been to save the file and reopen it. Try that.

Since, by posting this reply, your post will now be shown in today's MrExcel's postings, it is very probable that some one with more useful knowledge in this will read it and answer, with a good solution. Good luck.