Microsoft Office Forums - View Single Post - [Solved] Dragging conditional formatting like a formula

Thread: [Solved] Dragging conditional formatting like a formula

View Single Post

Old

11-04-2012, 02:28 AM

grizz

grizz is offline

grizz uses Windows XP

Windows XP grizz uses Office 2003

grizz uses Office 2003

Office 2003

Novice

Join Date: Jan 2012

Posts: 28

grizz is on a distinguished road

Default

remove the $ from your formula --- highlight B1:B3 --- COPY --- highlight C1:Z3 --- PASTE SPECIAL / click formats & OK
Z3 is just a cell go as far as required

Reply With Quote