Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can cell's act like time clock at a certen time/date for payments
i was wondering if one can use a sheet cell of a particuler item, to function
like a time clock to remind of schedule payments. i have created a basic family budget planner which has in cridet cards to be paid. |
#2
|
|||
|
|||
You might investigate the use of 'Conditional Formatting' to change the
background colour of a cell when today's date (TODAY()) has some meaning in relation to the pay date. eg. Red when overdue, yellow when due in 5 days time, otherwise green. HTH, Fred "Colin2u" wrote: i was wondering if one can use a sheet cell of a particuler item, to function like a time clock to remind of schedule payments. i have created a basic family budget planner which has in cridet cards to be paid. |
#3
|
|||
|
|||
I'm not sure I would go all the way to time, but using dates seems reasonable to
me. I put the bill name in column A2 I put the date due in column B2 I put "paid" in column C2 (or left blank if not paid) I put this formula in D2: =IF(A2="","",IF(C2<"","", IF(B2-TODAY()=0,"Due in: ","Overdue by: ")&ABS(B2-TODAY())&" days")) (all one cell) Then with D2 selected I used format|conditional formatting formula is: =LEFT(D2,4)="over" and give it a bold, red font. And then I dragged D2 down that column as far as I needed it. If column A is empty, you won't see anything. If column C has something in it, then you won't see anything, too. Colin2u wrote: i was wondering if one can use a sheet cell of a particuler item, to function like a time clock to remind of schedule payments. i have created a basic family budget planner which has in cridet cards to be paid. -- Dave Peterson |
#4
|
|||
|
|||
Somehow this formula do not work (even when protecting the worksheet/book.).
IS THERE ANOTHER WAY TO DO THIS? "Dave Peterson" wrote: I'm not sure I would go all the way to time, but using dates seems reasonable to me. I put the bill name in column A2 I put the date due in column B2 I put "paid" in column C2 (or left blank if not paid) I put this formula in D2: =IF(A2="","",IF(C2<"","", IF(B2-TODAY()=0,"Due in: ","Overdue by: ")&ABS(B2-TODAY())&" days")) (all one cell) Then with D2 selected I used format|conditional formatting formula is: =LEFT(D2,4)="over" and give it a bold, red font. And then I dragged D2 down that column as far as I needed it. If column A is empty, you won't see anything. If column C has something in it, then you won't see anything, too. Colin2u wrote: i was wondering if one can use a sheet cell of a particuler item, to function like a time clock to remind of schedule payments. i have created a basic family budget planner which has in cridet cards to be paid. -- Dave Peterson |
#5
|
|||
|
|||
What happens when you try the formula?
In fact, who is your data laid out and what is the formula you used? Colin2u wrote: Somehow this formula do not work (even when protecting the worksheet/book.). IS THERE ANOTHER WAY TO DO THIS? "Dave Peterson" wrote: I'm not sure I would go all the way to time, but using dates seems reasonable to me. I put the bill name in column A2 I put the date due in column B2 I put "paid" in column C2 (or left blank if not paid) I put this formula in D2: =IF(A2="","",IF(C2<"","", IF(B2-TODAY()=0,"Due in: ","Overdue by: ")&ABS(B2-TODAY())&" days")) (all one cell) Then with D2 selected I used format|conditional formatting formula is: =LEFT(D2,4)="over" and give it a bold, red font. And then I dragged D2 down that column as far as I needed it. If column A is empty, you won't see anything. If column C has something in it, then you won't see anything, too. Colin2u wrote: i was wondering if one can use a sheet cell of a particuler item, to function like a time clock to remind of schedule payments. i have created a basic family budget planner which has in cridet cards to be paid. -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
this is what I want to do.
I want to have a particuler cell next to the bill name with the date when it is due and if posible another or the same cell actvate (flashs) at least 4 business days prier to the due date of being over due. all this is to be done automatically. what i am trying to do is to have the item dummy roof to othe other user in the household. thankyou "Dave Peterson" wrote: What happens when you try the formula? In fact, who is your data laid out and what is the formula you used? Colin2u wrote: Somehow this formula do not work (even when protecting the worksheet/book.). IS THERE ANOTHER WAY TO DO THIS? "Dave Peterson" wrote: I'm not sure I would go all the way to time, but using dates seems reasonable to me. I put the bill name in column A2 I put the date due in column B2 I put "paid" in column C2 (or left blank if not paid) I put this formula in D2: =IF(A2="","",IF(C2<"","", IF(B2-TODAY()=0,"Due in: ","Overdue by: ")&ABS(B2-TODAY())&" days")) (all one cell) Then with D2 selected I used format|conditional formatting formula is: =LEFT(D2,4)="over" and give it a bold, red font. And then I dragged D2 down that column as far as I needed it. If column A is empty, you won't see anything. If column C has something in it, then you won't see anything, too. Colin2u wrote: i was wondering if one can use a sheet cell of a particuler item, to function like a time clock to remind of schedule payments. i have created a basic family budget planner which has in cridet cards to be paid. -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
I would use that formula and format the cell in big red bold letters.
Colin2u wrote: this is what I want to do. I want to have a particuler cell next to the bill name with the date when it is due and if posible another or the same cell actvate (flashs) at least 4 business days prier to the due date of being over due. all this is to be done automatically. what i am trying to do is to have the item dummy roof to othe other user in the household. thankyou "Dave Peterson" wrote: What happens when you try the formula? In fact, who is your data laid out and what is the formula you used? Colin2u wrote: Somehow this formula do not work (even when protecting the worksheet/book.). IS THERE ANOTHER WAY TO DO THIS? "Dave Peterson" wrote: I'm not sure I would go all the way to time, but using dates seems reasonable to me. I put the bill name in column A2 I put the date due in column B2 I put "paid" in column C2 (or left blank if not paid) I put this formula in D2: =IF(A2="","",IF(C2<"","", IF(B2-TODAY()=0,"Due in: ","Overdue by: ")&ABS(B2-TODAY())&" days")) (all one cell) Then with D2 selected I used format|conditional formatting formula is: =LEFT(D2,4)="over" and give it a bold, red font. And then I dragged D2 down that column as far as I needed it. If column A is empty, you won't see anything. If column C has something in it, then you won't see anything, too. Colin2u wrote: i was wondering if one can use a sheet cell of a particuler item, to function like a time clock to remind of schedule payments. i have created a basic family budget planner which has in cridet cards to be paid. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Subtracting Cells formatted with Date AND Time to get hours? | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |