Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim

there has been a lot of post on this topic, Please search. I have put several
answers as have several others.

"Jim Brass" wrote:

Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim

Hi Jim ,

See XlDynamics CFPlus page at :

http://www.xldynamic.com/source/xld.....Download.html

---
Regards,
Norman



"Jim Brass" wrote in message
...
Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim

Hi Jim,
see
http://www.mvps.org/dmcritchie/excel/event.htm

or see Extended Conditional Formatting add-on (Bob Phillips & Frank Kabel)
http://www.xldynamic.com/source/xld.....Download.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jim Brass" wrote in message ...
Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim

True but unfortunately if you look up words like conditional formatting
in a search that isn't going to help much with finding the solutions
with extended formatting. It might help to include limit* 3 OR three
of course adding your name to the search would help, but that is
not something the person would know ahead of time -- though maybe
the suggestion is just the way find them now at the time of posting..

google groups search: conditional.formatting 3 OR three author:patrick.molloy

(note the period instead of using double quote for "patrick molloy")
Anyway that limits it to 55:

and not very recent, okay change it to
google groups search: conditional.formatting author:patrick.molloy .
(sorted by date) I'll bet the results still aren't what you expected.

Anyway it is hard to search for answers for things that are most commonly
done differently. Likewise there are so many answers that if you
misspell a word on a normal search you'll still get a hit and that's not
even taking into account that Google will suggest a new search with
the word spelled as Google has found it more often spelled..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Patrick Molloy" wrote in message
...
there has been a lot of post on this topic, Please search. I have put several
answers as have several others.

"Jim Brass" wrote:

Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim

ok ok
sorry everybody. Next time I'll post a full reply.


"David McRitchie" wrote in message
...
True but unfortunately if you look up words like conditional formatting
in a search that isn't going to help much with finding the solutions
with extended formatting. It might help to include limit* 3 OR three
of course adding your name to the search would help, but that is
not something the person would know ahead of time -- though maybe
the suggestion is just the way find them now at the time of posting..

google groups search: conditional.formatting 3 OR three
author:patrick.molloy

(note the period instead of using double quote for "patrick molloy")
Anyway that limits it to 55:

and not very recent, okay change it to
google groups search: conditional.formatting author:patrick.molloy .
(sorted by date) I'll bet the results still aren't what you expected.

Anyway it is hard to search for answers for things that are most commonly
done differently. Likewise there are so many answers that if you
misspell a word on a normal search you'll still get a hit and that's not
even taking into account that Google will suggest a new search with
the word spelled as Google has found it more often spelled..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Patrick Molloy" wrote in
message
...
there has been a lot of post on this topic, Please search. I have put
several
answers as have several others.

"Jim Brass" wrote:

Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim

This code snippet should be placed in the worksheet's code page.
Its a simple demonstration of setting multicolor conditions

Option Explicit
' example code for conditional formatting
' sets a row to a color based off
' cell value in column A
Enum colors
Red = 255
Green = 65280
Blue = 16711680
Yellow = 65535
Amber = 52479
Purple = 16711935
White = xlNone
End Enum
Sub setcolors(Target As Range, color As Long)
With Target
.Interior.color = color
End With
End Sub
Sub CheckA()
CheckConditions Range("A:A")
End Sub
Sub CheckConditions(Target As Range)
Dim cell As Range
Dim color As Long
For Each cell In Target
Select Case cell.Value
Case Is < -10
color = colors.Red
Case Is < 0
color = colors.Amber
Case Is = 0
color = colors.Yellow
Case Is 100
color = colors.Green
Case Is 50
color = colors.Blue
Case Else
color = colors.White
End Select
setcolors Range(Cells(cell.Row, 1), Cells(cell.Row, "F")), color
Next
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
CheckConditions Target
End If
End Sub


Patrick Molloy
Microsoft Excel MVP

http://www.xl-expert.com/Files/Excel_Conditions.xls

"Jim Brass" wrote in message
...
Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim