Dragging conditional formatting like a formula

		Microsoft Office Forums > Microsoft Excel > Excel
Dragging conditional formatting like a formula

FAQ

Thread Tools

Display Modes

11-04-2012, 02:28 AM

grizz

Windows XP Dragging conditional formatting like a formula

Office 2003

Novice

Join Date: Jan 2012

Posts: 28

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Formula - Conditional replacement of cells	mag	Excel	0	10-27-2012 08:30 PM
Conditional Formula	UICOMP	Excel	1	05-18-2012 12:59 PM
Need formula for search and conditional formatting	MikeJedi	Excel	9	01-13-2012 12:38 PM
conditional formatting formula	NEHicks503	Excel	1	11-30-2011 09:01 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 PM.