Conditional formatting

  • Thread starter Thread starter ~Alan Rosenberg Miami
  • Start date Start date
A

~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
 
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
 
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
 
Back
Top