PC Review


Reply
Thread Tools Rate Thread

changing colors of a cell

 
 
=?Utf-8?B?QmVu?=
Guest
Posts: n/a
 
      13th Feb 2007
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
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      13th Feb 2007
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:17 PM.