changing colors of a cell

's Computer Specifications

My problem is that I need to change the colors of cells based on the values
of Lot 51, East Pavilion and West Pavilion if you could help me out with this
that would be great

's Computer Specifications

See if you can work with this.

If Cells(Lot51Row, Lot51Col) = "YourCriteriaValue" Then
Range("CellsToChangeColor").Interior.ColorIndex = ANumberFrom1To56
End If

"Ben" wrote:

> My problem is that I need to change the colors of cells based on the values
> of Lot 51, East Pavilion and West Pavilion if you could help me out with this
> that would be great

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: changing a cell to different colors	Project Mangler	Microsoft Excel Programming	0	4th May 2010 09:24 PM
Changing cell colors	Joebeone	Microsoft Excel Misc	1	11th Feb 2010 07:17 PM
Re: Changing cell colors in a row IF...	Debra Dalgleish	Microsoft Excel Programming	0	15th Jan 2007 10:46 PM
Cell colors or text color changing when date in cell gets closer.	=?Utf-8?B?Q2hhc2U=?=	Microsoft Excel Worksheet Functions	5	19th Oct 2006 08:57 AM
Changing Cell Colors	Ed'	Microsoft Excel Discussion	1	31st Aug 2004 01:44 AM