Re: $$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

2016-04-12 Thread Johnny
Paul, thanks for taking a look. I start by copying the contents of the MASTER SAVE tab and paste values into Cell A1 of Worksheet tab. I then run the macro NCFL_cleanup to get rid of everything on that page except the single column of data I want to use. The idea is then to paste the column of

Re: $$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

2016-04-12 Thread Paul Schreiner
Can you attach an example?It's difficult to guess what MIGHT be happening based on your description. When you "copy" the data into the cells, are you pasting the entire contents or have you tried to "Paste Special -> Values"? Are the values numeric or alpha-numeric? It's possible when you copy

$$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

2016-04-12 Thread Johnny
Hi All, I searched for an answer on this first but I'm hoping for some easy, good advice. Using VBA, I have preloaded some cells with formula-based conditional formatting. When I copy a column of data into these cells, the conditional formatting does not take effect. Also, formulas in