Friday, December 19, 2008

How to change the color of alternative rows in excel

today i came across a situation like, i wanted to change the background color of alternative raws in an excel sheet.i'd seen it in many web pages.

the trick is

1.select the needed area in your excel sheet
2.go to Format > Conditional Formatting
3.select 'forumla is' from the combo box
4.give the formula =mod(row(),2)=1
5.select the color
6.click ok

Got the trick? it was a new information for me, and its really a cool trick.

Monday, December 8, 2008

Contol Escape in vi editor

Control Escape is a special charecter, which used for many PCL commands, its prerry hard to copy paste these in to a vi editor directly from a html/pdf/text PCL documents.

But you can simulate this charecter in vi editor. for that press

control+v and then escape, ( press the keys in the same order donot release any of the keys till you pressed the escape ). the equivalent ASCII is '\033'.