excel
Excel Tip - How to extract first 20 characters from the string
Today I was working on excel (yeah yeah I do work sometimes), I wanted to extract the first 20 characters from the string. I forgot the function name, I did a quick google search and found out the solutions.
How to change the background color of entire row in Excel using VBA code - Conditional
My friend Vinod gave me a problem to change the background color of entire row to Red and also to change the font to bold. It seems to be an easy task but there are two constraints.
1. He want to do this only for those lines which has font color of red.
Want to contact me?
Ravi Sagar
ravi at sparxsys dot com
Author of "Mastering JIRA 7" book. Loves #Jira and #Drupal. #Blogger, #ProblemSolver, #Atlassian #Consultant and #Technologist @ravisagar on twitter
Want my help? raise a support request for me.
Social and other Links
- RSS Feed
- Github
- @ravisagar on Twitter
- Ravi Sagar YouTube: Atlassian tools and Jira tutorials
- Ravi Sagar LBRY: Synced with Ravi Sagar YouTube
- Blackberry Boy YouTube: Linux, Emacs, Org Mode and tech tutorials
- Ravi Sagar Podcast
- @ravisagar.in on Instagram
- Ravi.pro: site published with Org Mode, general IT and tech stuff
- LinuxIndya.com: site published with Org Mode on Linux
- AutoGrid.info: site published with Org Mode on Excel VBA and Google Apps Script