vba fill down conditional formatting to last row with data in a table

willow1985

Well-known Member
Joined
Jul 24, 2019
Messages
929
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have a macro for a spreadsheet that updates from one Sheet to another report with a table. It updates only 1 row at a time (which is all that is required) and I was wondering how can I copy down the conditional formatting once the information is pasted? The below code copies the information from Range A2:J2 from the "New NCR" Sheet goes to Sheet NCR Log, finds the first blank cell in Column A and pastes special values.

Sheets("New NCR").Select
Range("A2:J2").Select
Selection.Copy
Sheets("NCR Log").Select
Range("NCRLog").Cells(1, 1).End(xlDown).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

After this I would like to bring down the conditional formatting from the row above column: A:J then continue with the rest of my code.

Any help would be most appreciated.

Thank you!

Carla
 
Last edited:

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
The table seems to be automatically copying down the conditional formatting now....strange. Well so far it is working without manually having to copy it down. Hope it continues to do so.
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top