Thread
:
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER
View Single Post
#
3
Posted to microsoft.public.excel.misc
[email protected]
external usenet poster
Posts: 4
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER
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.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]