Tag Archives: Excel

Conditional Formatting – Excel

Posted on September 14, 2017 by vijred

Simple tip on using Conditional formatting. This sample is to format a cell if it exceeds certain threshold (which is a different column on the same row). 1. Identify first row, first column where the formula needs to be created. … Continue reading →

Posted in Productivity, Uncategorized | Tagged , , | Leave a comment

Tip – Excel formula to convert Instance Name to Server Name

Posted on December 1, 2016 by vijred

Below formula will give sub string preceding \

Posted in Script, Uncategorized | Tagged , , , , , | Leave a comment

Excel conditional formatting to highlight the difference between 2 data sets

Posted on August 6, 2015 by vijred

I had a situation to provide differences between 2 data sets with most readable format to business, based on existing data and differences business will make a decision on next course of action. After multiple different experiments, I have provided … Continue reading →

Posted in Productivity, Uncategorized | Tagged , | Leave a comment

Avoid Next Line character in SSMS results

Posted on July 31, 2015 by vijred

Many a time we copy data from SQL Server Management Studio results pane into Excel while preparing reports and analyzing the data. One of the most common problem is handling Next Line characters. These characters disrupts the indentation of data … Continue reading →

Posted in Productivity, SQL Server, SSMS | Tagged , , , , | Leave a comment