Color a row of excel based on cell date time value (Today)

  1. Select all rows of excel in which you want to apply formula. There must be a date time filed on which you will apply rule. Suppose, column A is date time column and it is started from A2
  2. Conditional Formatting -> New Rule -> Use formula to determine which cell to format
  3. Write in format value text box:  =$A2=TODAY()
  4. Click Format button -> select fill tab -> and select color -> Click Ok
  5. Finally click ok in the dialog box to apply.

Solution disappears in solution explorer : Visual Studio 2010

I installed visual studio 2010 in my pc. I created a blank solution. When ever I add a project to the solution the original i.e root solution is disappear. This means that as soon as you add a project to a blank solution, the solution disappears and you are unable to add another project. I spent a lot of time to solve the problem. It is very easy.

To do this, goto tools->options->Projects and Solution and check the “Always show solution” option.

First program using visual studio 2010

Hopefully you have already installed visual studio 2010. If you didn’t install yet, Install Visual Studio 2010 Step by Step.

So, let’s try to write our first program in visual studio 2010.

Step 1: Click Start -> Program -> Microsoft Visual Studio 2010 -> Microsoft Visual Studio 2010.

1

Step 2: If you open Visual Studio 2010 first time after installation in your computer. You will see the following screen. Select Visual C# Development Settings and click Start Visual Studio. We have selected Visual C# Development Settings because we will work with C#.

2

Step 3: After Clicking Start Visual Studio at previous steps you will see the following screen. Click File -> New -> Project.

3

4

Application among the projects. Note that I have changed my project location and Project name. You can keep default location and name.

5

Step 5:  Now you will see the following screen where you will develop your first program. You will see default code snippet which comes automatically.

6

System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MyFirstProgram
{
class Program
{
static void Main(string[] args)
{

}
}
}

Add a simple statement in the Main Method:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MyFirstProgram
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("This is my first program in C#");
}
}
}

Step 6: Click Debug -> Start Without Debugging or Press – Ctrl+F5. You will see the following screen.

Output:

7

Yes! You have done! This is your first program in C#. Happy

Install Visual Studio 2010 Step by Step

Visual studio 2010 has eight major versions.
1. Ultimate
2. Premium
3. Professional
4. Express
5. Team Foundation
6. Test Professional
7. Team Explorer Every Where
8. Light Switch

The clear picture of Visual Studio 2010 is given below

0Prerequisite to install visual studio 2010

  1. Disable anti-virus or anti-spyware software
  2. Close all of your running software
  3. If you are using windows xp make sure it is service pack 3
  4. If you install other than windows xp make sure it is service pack 2 or more
  5. 1 GB RAM
  6. 3 GB of Hard disk space

Step by Step installation

Let’s start to install visual studio 2010. Here I will install visual studio 2010 Ultimate Edition. You can install it from hard disk or DVD ROM. If you install it from DVD ROM, visual studio 2010 will run automatically. I am installing it from my hard disk.

Step 1: Double click on setup.exe

0.1

Step 2: After clicking setup.exe file, you will see the following screen. Click Install Microsoft Visual Studio 2010

St-2

Step 3: Click next to start installation.

st-3

Step 4: After clicking next you will see the following screen.

01button I accept the license term

02

Step 6: Select the features that you want to install and the path you want to install visual studio 2010. If you don’t select path it will install in default location. You can select either Full or Custom features. If you select custom you have to select features which you want to install. For the beginner I suggest to select full feature.

st-5

Step 7: Then the setup will start to install its components.

st-7

Step 8: Reboot your computer. To complete installation you may have to reboot your computer for one or twice

05

Step 9: After the rebooting, the setup will start again

6

Step 10: The setup starts to install the rest of the components.

07Step 11: The installation complete.

complete
If you see the above screen, your installation completes. So, let cheers!!!