Extend conditional formatting

[lou78]

Hi - grateful for any help.
I have a table and need to identify errors
Namely I want E2 to turn red if greater than C2...that fine but when I try to extend to look at each row in turn ie E3>c3, E4>c4 im getting some strange results....

THANKS IN ADVANCE......

 

[Special-K99]

Clear any previous conditional formatting in the range you want to format

Starting at E2 select the entire range to format

Conditional Formatting
New Rule
Use a formula to determine...

=(E2>C2)

Format as red

 

[lou78]

figured it - however - can I copy and paste conditional formation to another tab in the work book which already contains data?

 

[Special-K99]

I think copy paste special format will do this.