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