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

 

[Wolfman]

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

 

[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)

 

[Tred]

Thanks Bob!

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)

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