Can Excel automatically highlight dates in the next week?

  • Thread starter Thread starter georgiakate1039
  • Start date Start date
G

georgiakate1039

I'm using excel 2003. I want to make it easier to see when borrowed items
need to be returned soon. Is this possible?
 
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
Format>Cells>Number>General
Copy down column B as far as required

Column B will show how many days have elapsed since the item was borrowed.
 
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
 
Mike H said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight Expired dates 1
Excel adding days to dates 4
highlight cells 4
Highlight expiry date 4
can the cell the cursor is on be highlighted a different color ? 1
Automatically highlight max and min values in a column in Excel 2
Conditional Formatting - Dates 2
Date filters in List for Excel 2003? 1

Back
Top