Meaux

Posts: n/a

Copying a conditional format

Is there a way to copy just the conditional format of a cell that uses a
formula as its condition. Such as "=h4.5" . What I want to do is use the
same format for different cells down a column. The "h4" has to change to
whatever row the copied format is on. So if I copy the conditional format on
"A4" that has the formula "H4.5" and copy it to row "5" the conditional
format should read "H5.5".

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional format of data tables in charts	[email protected]	Charts and Charting in Excel	2	January 25th 05 03:56 PM
copy conditional format as ACTUAL format	Dana Zulager	Excel Discussion (Misc queries)	7	December 7th 04 11:02 PM
make a conditional format the default	Fred Evans	Excel Discussion (Misc queries)	3	December 6th 04 05:01 AM
Conditional format	rexmann	Excel Discussion (Misc queries)	4	December 2nd 04 12:01 PM
Conditional Format With SUMIF	Minitman	Excel Worksheet Functions	3	November 1st 04 02:58 PM

All times are GMT +1. The time now is 04:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us