Conditional Formatting by Date

[Wolfman]

Howdy All,


I have a budget workbook which contains a worksheet for every month and I
need to format certain cells to show a value from a specific date forward.

Example:

Car payment needs to be applied on the 15th and remain there when the month
rolls over. So on the fifteenth of May, I need cell C5 to display $350.00,
but I don't want May's C5 to reset back to 0 when the date rollovers over to
June 1st.

I hope I am clear on this.

Thanks for you time and attention,
Brian

[via135]

hi!

in A1: =TODAY()

and

in C5: =(IF(AND(MONTH(A1)=5,DAY(A1)=15),TEXT(350,"$000"),""))

-via135

Howdy All,


I have a budget workbook which contains a worksheet for every month and I
need to format certain cells to show a value from a specific date forward.

Example:

Car payment needs to be applied on the 15th and remain there when the month
rolls over. So on the fifteenth of May, I need cell C5 to display $350.00,
but I don't want May's C5 to reset back to 0 when the date rollovers over to
June 1st.

I hope I am clear on this.

Thanks for you time and attention,
Brian

[Wolfman]

Thanks Via, but if the date is anything BUT the 15th, the cell displays
nothing


"via135" <via135.273fyy_1146428101.2121@excelforum-nospam.com> wrote in
message news:via135.273fyy_1146428101.2121@excelforum-nospam.com...
>
> hi!
>
> in A1: =TODAY()
>
> and
>
> in C5: =(IF(AND(MONTH(A1)=5,DAY(A1)=15),TEXT(350,"$000"),""))
>
> -via135
>
>
> Wolfman Wrote:
>> Howdy All,
>>
>>
>> I have a budget workbook which contains a worksheet for every month and
>> I
>> need to format certain cells to show a value from a specific date
>> forward.
>>
>> Example:
>>
>> Car payment needs to be applied on the 15th and remain there when the
>> month
>> rolls over. So on the fifteenth of May, I need cell C5 to display
>> $350.00,
>> but I don't want May's C5 to reset back to 0 when the date rollovers
>> over to
>> June 1st.
>>
>> I hope I am clear on this.
>>
>> Thanks for you time and attention,
>> Brian
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=537605
>

[Bob Phillips]

If you use sheet names like Apr-200, May-2006, you could use this

=IF(TODAY()>=DATEVALUE("15-"&MID(CELL("filename",A1),FIND("]",CELL("filename
",A1))+1,255)),350,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Wolfman" <wolfmanx@charter.net> wrote in message
news:uu7wIhLbGHA.3524@TK2MSFTNGP04.phx.gbl...
> Thanks Via, but if the date is anything BUT the 15th, the cell displays
> nothing
>
>
> "via135" <via135.273fyy_1146428101.2121@excelforum-nospam.com> wrote in
> message news:via135.273fyy_1146428101.2121@excelforum-nospam.com...
> >
> > hi!
> >
> > in A1: =TODAY()
> >
> > and
> >
> > in C5: =(IF(AND(MONTH(A1)=5,DAY(A1)=15),TEXT(350,"$000"),""))
> >
> > -via135
> >
> >
> > Wolfman Wrote:
> >> Howdy All,
> >>
> >>
> >> I have a budget workbook which contains a worksheet for every month and
> >> I
> >> need to format certain cells to show a value from a specific date
> >> forward.
> >>
> >> Example:
> >>
> >> Car payment needs to be applied on the 15th and remain there when the
> >> month
> >> rolls over. So on the fifteenth of May, I need cell C5 to display
> >> $350.00,
> >> but I don't want May's C5 to reset back to 0 when the date rollovers
> >> over to
> >> June 1st.
> >>
> >> I hope I am clear on this.
> >>
> >> Thanks for you time and attention,
> >> Brian
> >
> >
> > --
> > via135
> > ------------------------------------------------------------------------
> > via135's Profile:
> > http://www.excelforum.com/member.php...o&userid=26725
> > View this thread:
http://www.excelforum.com/showthread...hreadid=537605
> >
>
>

[Tred]

Thanks Bob!

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23Xqs7RXbGHA.4716@TK2MSFTNGP03.phx.gbl...
> If you use sheet names like Apr-200, May-2006, you could use this
>
> =IF(TODAY()>=DATEVALUE("15-"&MID(CELL("filename",A1),FIND("]",CELL("filename
> ",A1))+1,255)),350,"")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Wolfman" <wolfmanx@charter.net> wrote in message
> news:uu7wIhLbGHA.3524@TK2MSFTNGP04.phx.gbl...
>> Thanks Via, but if the date is anything BUT the 15th, the cell displays
>> nothing
>>
>>
>> "via135" <via135.273fyy_1146428101.2121@excelforum-nospam.com> wrote in
>> message news:via135.273fyy_1146428101.2121@excelforum-nospam.com...
>> >
>> > hi!
>> >
>> > in A1: =TODAY()
>> >
>> > and
>> >
>> > in C5: =(IF(AND(MONTH(A1)=5,DAY(A1)=15),TEXT(350,"$000"),""))
>> >
>> > -via135
>> >
>> >
>> > Wolfman Wrote:
>> >> Howdy All,
>> >>
>> >>
>> >> I have a budget workbook which contains a worksheet for every month
>> >> and
>> >> I
>> >> need to format certain cells to show a value from a specific date
>> >> forward.
>> >>
>> >> Example:
>> >>
>> >> Car payment needs to be applied on the 15th and remain there when the
>> >> month
>> >> rolls over. So on the fifteenth of May, I need cell C5 to display
>> >> $350.00,
>> >> but I don't want May's C5 to reset back to 0 when the date rollovers
>> >> over to
>> >> June 1st.
>> >>
>> >> I hope I am clear on this.
>> >>
>> >> Thanks for you time and attention,
>> >> Brian
>> >
>> >
>> > --
>> > via135
>> > ------------------------------------------------------------------------
>> > via135's Profile:
>> > http://www.excelforum.com/member.php...o&userid=26725
>> > View this thread:
> http://www.excelforum.com/showthread...hreadid=537605
>> >
>>
>>
>
>