Conditional formatting

[~Alan Rosenberg Miami]

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. E3>0 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. E3>0 turn green 2.E3<0

Question: How can I copy the three rows and past them so the
Conditional formatting follows the row Number

 

[Gord Dibben]

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 =E3>0, not =$E$3>0

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

 

[~Alan Rosenberg Miami]

I am not sure on how to use it to achieve the results that I ineed?

 

[~Alan Rosenberg Miami]

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$3>0
and if this =$E$3>0 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