Conditional formatting
Conditional formatting XL2000
3 rows 8 columns have Conditional formatting Problem : When I try to copy the 3 rows the Conditional formatting the information stays the same as the fist 3 rows "I hope this makes sence " Conditional formatting is set up with "formula is" 1. E30 turn green 2.E3<0 turn red ok this works good When I copy and past or highlight and drag To row 4 the Conditional formatting stays 1. E30 turn green 2.E3<0 Question: How can I copy the three rows and past them so the Conditional formatting follows the row Number |
Conditional formatting
Alan
First of all........in which cell are you placing the CF? If in E3, you don't need a "formula is". "Cell value is" greater than will do. If CF not in E3, make sure that the formula reads =E30, not =$E$30 BTW....I notice you left out the "=" signs in your example. Was that a typo? I would use the Format Painter(brush icon) to copy the formats to other cells. although the drag/copy works also. Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Sun, 13 Jul 2003 17:53:50 -0400, ~Alan Rosenberg Miami wrote: Conditional formatting XL2000 3 rows 8 columns have Conditional formatting Problem : When I try to copy the 3 rows the Conditional formatting the information stays the same as the fist 3 rows "I hope this makes sence " Conditional formatting is set up with "formula is" 1. E30 turn green 2.E3<0 turn red ok this works good When I copy and past or highlight and drag To row 4 the Conditional formatting stays 1. E30 turn green 2.E3<0 Question: How can I copy the three rows and past them so the Conditional formatting follows the row Number |
Conditional formatting
I am not sure on how to use it to achieve the results that I ineed?
Henry wrote: Alan, Have you tried Format Painter (the paintbrush icon on the standard toolbar)? HTH Henry "~Alan Rosenberg Miami" wrote in message ... Conditional formatting XL2000 3 rows 8 columns have Conditional formatting Problem : When I try to copy the 3 rows the Conditional formatting the information stays the same as the fist 3 rows "I hope this makes sence " Conditional formatting is set up with "formula is" 1. E30 turn green 2.E3<0 turn red ok this works good When I copy and past or highlight and drag To row 4 the Conditional formatting stays 1. E30 turn green 2.E3<0 Question: How can I copy the three rows and past them so the Conditional formatting follows the row Number |
Conditional formatting
I am placing alot of them a b c row 3 refers to E2. while d3 refers to E2 and
so on And yes it was a typo. Its the XL200 that does this =$E$30 and if this =$E$30 is incorrect then why does XL format it that way? I know to confuse us lamers :) I will try without the $ and see what happens thank you Gord Dibben wrote: Alan First of all........in which cell are you placing the CF? If in E3, you don't need a "formula is". "Cell value is" greater than will do. If CF not in E3, make sure that the formula reads =E30, not =$E$30 BTW....I notice you left out the "=" signs in your example. Was that a typo? I would use the Format Painter(brush icon) to copy the formats to other cells. although the drag/copy works also. Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Sun, 13 Jul 2003 17:53:50 -0400, ~Alan Rosenberg Miami wrote: Conditional formatting XL2000 3 rows 8 columns have Conditional formatting Problem : When I try to copy the 3 rows the Conditional formatting the information stays the same as the fist 3 rows "I hope this makes sence " Conditional formatting is set up with "formula is" 1. E30 turn green 2.E3<0 turn red ok this works good When I copy and past or highlight and drag To row 4 the Conditional formatting stays 1. E30 turn green 2.E3<0 Question: How can I copy the three rows and past them so the Conditional formatting follows the row Number |
All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com