MrExcel Publishing
Your One Stop for Excel Tips & Solutions

colors


Posted by Lewis on May 18, 2001 5:36 PM

Is there a macro or somthing that can go through a set block of cells and if the cells value is < say 90 change the color to something else?

thanx

-Lewis


Posted by Capulet Mercutio on May 18, 2001 5:59 PM

Dim cell As Range
For Each cell In 'your range'
If cell.Value < 90 Then cell.Interior.ColorIndex = 3
Next


Posted by Dave Hawley on May 19, 2001 12:32 PM

Hi Lewis

Excel has a built in feature fo this called "Conditional Formatting", it can be found under "Format" on the MenuBar.

Let's say the range you want to color cells that are greater than 90 is A1:D100.

Select the range.
Go to Format>Conditional formatting.
Select "Greater than"
Type: 90
Click "Format" and make your choice.
Click Ok then Ok again

Any good ?


Dave

OzGrid Business Applications