ASP.NET, SQL Server, WPF, C#, VB.NET

I'm working on a spreadsheet and I want certain colors to be associated with 
 
certain numbers (1 would = red; 2 would = blue, etc.).  How do I do this?

jackie923 wrote: 
 
Can you be more specific about the use you have in mind?  I can think 
 
of two different methods that may apply, however choosing one over the 
 
other would depend on the specific application you intend.  Please 
 
elaborate...?  In short, you will use either Conditional Formatting or 
 
a Custom Function using VBA. 
 
Lemme Know...