Applying conditional formatting to Mutiple cells in one shot? Please Help

I applied a conditional format for one cell.
The condition is this,
If the (1-Jan-07) Google ranking No. is greater than (1-Dec-06) the number is displayed in red & Bold
If the (1-Jan-07) Google ranking No. is lesser than (1-Dec-06) the number is displayed in green & Bold

Actually I applied the condition for one cell, How to apply this condition to mutiple cells/other cells using drag & drop or one shot.
If i select the conditional cell and drag to apply to other cells, the condition is applying but, the corresponding cell no. is not changing

Please Help!

Kind Attenation Forum Administor: I tried to attach a Excel file, but it is saying invalid file.

Regards
Ramki

Hi,

Have you tried to copy your conditional formatting with the Format Painter icon ... (looks like yellow brush ...) ?

HTH
Carim

Hi Friends,

Thanks for your reply. I am herewith attaching a sample Excel file (SearchEngineReport1.zip) for better clarify. Please tell how to implement conditional formating to mutiple cells in one shot or using drag and drop. Thanks in Advance

Regards
Ramki

Hi,

Attached is your corrected worksheet ...

But, as expected, the most important is the way to solve your problem ...
I did nothing but using the Format Painter icon ...

However, to do so one has to know the difference between relative and absolute references, for the formula to adjust itself ...

HTH
Carim

Hi Carim,

Thanks a ton. Thanks for your time. I also understand the difference between absolute & relative reference.

Ramki

You are welcome ...

Thanks for the feedback

Carim