Excel – Formula to check if cell contains specific string

=ISNUMBER(SEARCH(substring,text)) If you need to check if a cell contains a substring (specific text), you can do so with the Read More …

Change the row color based on a cell’s value (Excel)

Say, you have a table of your company orders like this: You may want to shade the rows in different Read More …

Automatically change incoming message colors and fonts (Outlook 2010 – 2013)

Conditional formatting is a way to make the incoming messages that meet defined conditions stand out in the message list Read More …

HTML – Clear Input Field Value When Selected

–> (Word) –> (PDF) –> (Epub) Often when creating forms on a website it is helpful to place descriptive text Read More …

Excel – Delete rows and columns using VBA

With the [gs macro]s below you can delete all empty rows or columns within a [gs worksheet] range. You can Read More …