Hi,
Pls. find attached a Excel Sheet (SearchEngineReport1.Zip). 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!
Regards
Ramki