Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the
conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
Select conditional formatting, and under condition 1, select "Formula is",
and in the formula, type "=MONTH(B1)=6" (for June), and change the 6 to 12 for December. HTH Alan P. "KiriumF1" wrote in message ... in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
From a post of mine earlier today. Change to suit to
select case month(target) Use a worksheet_event with select case to change your format,something like this. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then With Target Select Case Target.Value Case Is = 76 .Interior.ColorIndex = 3 '(red shade) Case Is = 52 .Interior.ColorIndex = 4 '(green shade) Case Is = 26 .Interior.ColorIndex = 46 '(orange shade) Case Is = 11 .Interior.ColorIndex = 41 '(blue shade) Case Is = 6 .Interior.ColorIndex = 6 '(yellow shade) End Select End With End If End Sub -- Don Guillett SalesAid Software "KiriumF1" wrote in message ... in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
Mmm, nothing happens, the dates are in the column B and there are about 2000
over rows. Should i put B3:B2000 or just B1? Both ways nothing happened. "Alan Perkins" wrote: Select conditional formatting, and under condition 1, select "Formula is", and in the formula, type "=MONTH(B1)=6" (for June), and change the 6 to 12 for December. HTH Alan P. "KiriumF1" wrote in message ... in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
Hi
are you sure your date values are stored as 'real excel' dates and not as 'Text'. Also in your example: - select B3:B2000 - goto the conditional format dialog -and enter only =MONTH(B3)=6 -- Regards Frank Kabel Frankfurt, Germany "KiriumF1" schrieb im Newsbeitrag ... Mmm, nothing happens, the dates are in the column B and there are about 2000 over rows. Should i put B3:B2000 or just B1? Both ways nothing happened. "Alan Perkins" wrote: Select conditional formatting, and under condition 1, select "Formula is", and in the formula, type "=MONTH(B1)=6" (for June), and change the 6 to 12 for December. HTH Alan P. "KiriumF1" wrote in message ... in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
Mmmm, i typed in 1st january as "1-jan" but when i click on the cell, it
shows 1/1/92. So not sure whether this is text or dates? "Frank Kabel" wrote: Hi are you sure your date values are stored as 'real excel' dates and not as 'Text'. Also in your example: - select B3:B2000 - goto the conditional format dialog -and enter only =MONTH(B3)=6 -- Regards Frank Kabel Frankfurt, Germany "KiriumF1" schrieb im Newsbeitrag ... Mmm, nothing happens, the dates are in the column B and there are about 2000 over rows. Should i put B3:B2000 or just B1? Both ways nothing happened. "Alan Perkins" wrote: Select conditional formatting, and under condition 1, select "Formula is", and in the formula, type "=MONTH(B1)=6" (for June), and change the 6 to 12 for December. HTH Alan P. "KiriumF1" wrote in message ... in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
Hi
you have to enter a valid date. That is WITH a year. You can then afterwards format it as D-MMM -- Regards Frank Kabel Frankfurt, Germany KiriumF1 wrote: Mmmm, i typed in 1st january as "1-jan" but when i click on the cell, it shows 1/1/92. So not sure whether this is text or dates? "Frank Kabel" wrote: Hi are you sure your date values are stored as 'real excel' dates and not as 'Text'. Also in your example: - select B3:B2000 - goto the conditional format dialog -and enter only =MONTH(B3)=6 -- Regards Frank Kabel Frankfurt, Germany "KiriumF1" schrieb im Newsbeitrag ... Mmm, nothing happens, the dates are in the column B and there are about 2000 over rows. Should i put B3:B2000 or just B1? Both ways nothing happened. "Alan Perkins" wrote: Select conditional formatting, and under condition 1, select "Formula is", and in the formula, type "=MONTH(B1)=6" (for June), and change the 6 to 12 for December. HTH Alan P. "KiriumF1" wrote in message ... in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do the conditional formatting for this?
If you use B1 in the formula is B1 the active cell within your selection?
in other words select the entire B column with the top row visible when you do that. If you wanted to color entire rows you would use $B1 in the formula =MONTH($B1)=6 and obviously choose a pattern color under format. http://www.mvps.org/dmcritchie/excel/condfmt.htm --- 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 "KiriumF1" wrote in message ... Mmm, nothing happens, the dates are in the column B and there are about 2000 over rows. Should i put B3:B2000 or just B1? Both ways nothing happened. "Alan Perkins" wrote: Select conditional formatting, and under condition 1, select "Formula is", and in the formula, type "=MONTH(B1)=6" (for June), and change the 6 to 12 for December. HTH Alan P. "KiriumF1" wrote in message ... in column B, i have dates in the form 1/1/92 to 31/12/92, how do i write the conditional formating, so that i can highlight particular months...for example, all june will be red, or all December will be red? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |