[[email protected]]

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.

[Claus Busch]

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

[[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.