Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color for last day of each month
Hello from Steved
I have an 12 month excel calendar I would like to have the last day of each month have a light yellow. If this is possible how. Thankyou. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
color for last day of each month
Something like this will give you all the last days of the month:
Sub test() Dim i As Byte For i = 1 To 12 MsgBox DateSerial(Year(Date), i, 1) - 1 Next End Sub RBS "Steved" wrote in message ... Hello from Steved I have an 12 month excel calendar I would like to have the last day of each month have a light yellow. If this is possible how. Thankyou. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
color for last day of each month
Format - Conditional Formatting
I'm trying formula is =EOMONTH(A1,0)=A1 and I think it should work. I'm getting an error "You may not use references to other worksheets or workbooks for Conditional Formatting criteria". Maybe someone else can assist. "Steved" wrote in message ... Hello from Steved I have an 12 month excel calendar I would like to have the last day of each month have a light yellow. If this is possible how. Thankyou. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
color for last day of each month
Thankyou
"Steved" wrote: Hello from Steved I have an 12 month excel calendar I would like to have the last day of each month have a light yellow. If this is possible how. Thankyou. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
color for last day of each month
On Wed, 11 Jan 2006 16:01:02 -0800, Steved
wrote: Hello from Steved I have an 12 month excel calendar I would like to have the last day of each month have a light yellow. If this is possible how. Thankyou. You can use conditional formatting. "Formula Is:" One formula that will return TRUE if the date in the cell is the last day of the month is: =MONTH(A1)<MONTH(A1+1) --ron |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
color for last day of each month
On Wed, 11 Jan 2006 19:17:33 -0500, "Barb Reinhardt"
wrote: Format - Conditional Formatting I'm trying formula is =EOMONTH(A1,0)=A1 and I think it should work. I'm getting an error "You may not use references to other worksheets or workbooks for Conditional Formatting criteria". Maybe someone else can assist. That won't work because EOMONTH is an ATP function, which is presently in a separate workbook. I understand the ATP functions will become part of Excel in Excel 12. Try: =Month(a1)<Month(a1+1) --ron |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
color for last day of each month
Hello from Steved
Thankyou. "Ron Rosenfeld" wrote: On Wed, 11 Jan 2006 16:01:02 -0800, Steved wrote: Hello from Steved I have an 12 month excel calendar I would like to have the last day of each month have a light yellow. If this is possible how. Thankyou. You can use conditional formatting. "Formula Is:" One formula that will return TRUE if the date in the cell is the last day of the month is: =MONTH(A1)<MONTH(A1+1) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif color cells with same month | Excel Discussion (Misc queries) | |||
Formula for CF to color current month | Excel Discussion (Misc queries) | |||
Auto Chg Tab Color vs Current Month | Excel Discussion (Misc queries) | |||
Change Cell Color if in current Month | Excel Worksheet Functions | |||
Show month in different color? | Excel Discussion (Misc queries) |