About Us

[email protected]

On Tuesday, December 30, 2014 10:26:26 AM UTC-6, Claus Busch wrote:
Hi,

Am Tue, 30 Dec 2014 08:18:46 -0800 (PST) schrieb
:

SCENARIO:
I HAVE CONDITIONED CELL C4 TO BE RED IF LESS THAN CELL C3. COLUMN "C" REPRESENTS JANUARY DATA. I WANT COLUMN "D" TO REPRESENT FEBRUARY, COLUMN "E" TO REPRESENT MARCH, AND SO ON AND SO ON. I WANT TO DRAG CELLS C4 AND D4 OVER AS TO COPY THE FORMATTING. HOWEVER, I WANT THE CONDITION TO CHANGE FOR EACH COLUMN. FOR EXAMPLE, CELL D4 TO BE RED IF LESS THAN CELL D3, AND CELL E4 TO BE RED IF LESS THAN E3. I CANNOT FIND A FAST WAY TO DO THIS. I AM CURRENTLY ADDING A NEW CONDITIONAL FORMAT FOR EACH CELL IN ROW 4. I HAVE HUNDREDS OF DATA POINTS THAT I NEED TO DO THIS FOR. IS THERE A FASTER WAY? THANKS IN ADVANCE FOR THE HELP.

select cell C4 = Conditional Formatting = New rule = Formula to
determine.... and use this formula:
=C4<C3 and choose your expected format.

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Thanks a ton. You just saved me a great amount of time.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying conditional formatting	zzdave	Excel Discussion (Misc queries)	5	March 15th 08 11:41 PM
Copying Conditional Formatting to range of cells	bman342	Excel Worksheet Functions	8	December 14th 07 03:57 AM
Copying Conditional Formatting to multiple cells	[email protected]	Excel Discussion (Misc queries)	2	April 10th 07 10:54 AM
Copying conditional formatting...HELP PLEASE!!!!	trixiebme	Excel Worksheet Functions	3	March 24th 05 01:53 PM
Copying cells with conditional formatting	Benfanfromlo	Excel Discussion (Misc queries)	3	February 10th 05 06:12 PM

Menu

About Us