View Single Post
Old 05-09-2019, 03:35 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 530
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about

Use PasteSpecial.ConditionalFormats. Or select the whole range you want to apply the conditional format to at start. And be sure you have absolute and relative reverences set properly (defining conditional formatting, the formula is written for topmost selected row, and the rule is copied down by excel like ordinary formula). Usually having row reference relative is enough.
Reply With Quote