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

Hi, In excel I freezed the first column (A1). Then I tried to freeze the first Row. I could not able to do that. In Windows Menu -> Unfreeze panes is there. How to freeze the first row and first column in excel? Please Help!

Hi, In excel i want to compare two values and indicate increase or decrease in the trend using color & bold for example Sep. (Revenue) - Oct. (Revenue) 100 - 200 Comparing the two values, if the october value is greater than september value then, the oct. value has to be shown in bold & green, like above one If the oct value is less than september value then, the oct. value has to be shown in bold & red. I am not a good programmer in vb. nor have good macro programming knowledge. Please enlighten me, How to achieve this. Please Help!