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

[ramki]

Hi,

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

[Anne Troy]

Sorry for the late response.

Use the format painter:

http://www.officearticles.com/misc/format_...soft_office.htm