View Single Post
 
Old 05-09-2019, 03:35 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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