Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel automatically highlight dates in the next week?
I'm using excel 2003. I want to make it easier to see when borrowed items
need to be returned soon. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel automatically highlight dates in the next week?
Hi
we're a bit light on detail here, but maybe what you want is with Date borrowed in column A, enter in B1 =IF(A1<"",TODAY()-A1,"") Format B1 as follows FormatCellsNumberGeneral Copy down column B as far as required Column B will show how many days have elapsed since the item was borrowed. -- Regards Roger Govier "georgiakate1039" wrote in message ... I'm using excel 2003. I want to make it easier to see when borrowed items need to be returned soon. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel automatically highlight dates in the next week?
Hi,
lets assume we have a return date in A1 and when you get it back you put something In b1 Select a1 and then Format|Conditional format Formula is =AND(A1<"",B1="",A1-TODAY()<=7) pick a colour OK A1 will now change colour when it is seven day or less to the return date and stay that way until you book it back in in B1 Use the format painter to paint this into other cells Mike "georgiakate1039" wrote: I'm using excel 2003. I want to make it easier to see when borrowed items need to be returned soon. Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel automatically highlight dates in the next week?
"Mike H" wrote: Hi, lets assume we have a return date in A1 and when you get it back you put something In b1 Select a1 and then Format|Conditional format Formula is =AND(A1<"",B1="",A1-TODAY()<=7) pick a colour OK A1 will now change colour when it is seven day or less to the return date and stay that way until you book it back in in B1 Use the format painter to paint this into other cells Mike "georgiakate1039" wrote: I'm using excel 2003. I want to make it easier to see when borrowed items need to be returned soon. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically highlight max and min values in a column in Excel | Excel Discussion (Misc queries) | |||
In Excel can I automatically highlight the row im working on? | Excel Discussion (Misc queries) | |||
Can Excel automatically color highlight entire row of cell I'm in | Excel Discussion (Misc queries) | |||
automatically highlight cells with expired dates?! | Excel Discussion (Misc queries) | |||
How do I highlight expired dates automatically in excel. | Excel Discussion (Misc queries) |