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.
These are the dumps from my daily learnings / challenges I faced in my work. hope it helps you too
Friday, December 19, 2008
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'.
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'.
Subscribe to:
Posts (Atom)