I am using the following VBA code to copy and paste the conditional formatting formula in cell Q4 to the last row in column Q. After pasting for example in cells Q5 to Q10, the 'Formula1' only changes correctly in Q5 and remains 'ISTEXT(Q5)),Q5>3' all the way down to cell Q10. I don't understand why it doesn't change to match the row number when pasted (e.g. Formula1 in cell Q9 should be 'ISTEXT(Q9)),Q9>3'). I can manually copy and paste one cell at a time down column Q and it works, but it doesn't work with the PasteSpecial. I hope this makes sense and would appreciate the help from any experts who have experienced this and know how to fix it. Thank you very much.
Bookmarks