Search results

Chandoo.. Thanks a lot. With what you suggested, and with a little tinkering with the formulas, I was able to get what I want. Many thanks for your help..

Hi, Chandoo.. Thanks a lot for your help. But when I try to copy the formula to the same column range below it, it does not work out. For example, I have input the following conditional formatting in cell A2: =A2>0.58*A1 and set format as Green =A2<=0.58*A1 and set format as Red But...

I want cell A2 to highlight "Green" if its value increases more than 58% of the value of cell A1. and I want cell A2 to highlight "Red" if its value decreases more than 58% of the value of cell A1. How can I do the above simultaneously on Excel 2010 conditional formatting? Your help will...

Varak, thank you very much for this macro. I tried it and it worked flawlessly. This will indeed save me a lot of time and boredom in doing my daily pricing. Once again thanks a lot for your assistance.

My question is similar to this. But it's for columns. I have a spreadsheet with 500 active columns, and I need to insert a blank column between each of these 500 columns. Now the hard way of doing this is to hold Ctrl key and select the column head of column b, then column c, then column d, and...