If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mark date that has passed
Hi!
I wonder if someone can help me finding the right function. I have a worksheet over dates. The left columns contains dates (my input) and the right column contains a function A1+15, A2+15 and so on, dates 15 days forward. Now I want Excel to help me find the dates (in the right column) that has passed. Is there a function for this? For example making the date red or fat. Thanks! /Michaela |
#2
|
|||
|
|||
Mark date that has passed
Hi,
Select B1 then Format|Conditional format Formula is enter the formula =AND($A1"",$B1TODAY()) Pick a colour OK Use the format painter to paint this conditional format down column B ike "Michaela" wrote: Hi! I wonder if someone can help me finding the right function. I have a worksheet over dates. The left columns contains dates (my input) and the right column contains a function A1+15, A2+15 and so on, dates 15 days forward. Now I want Excel to help me find the dates (in the right column) that has passed. Is there a function for this? For example making the date red or fat. Thanks! /Michaela |
#3
|
|||
|
|||
Mark date that has passed
Hi,
In column cell B1, enter the following formula in Format Conditional Formatting Formula is =TODAY()-$B10 Select the desired font. -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Michaela" wrote in message ... Hi! I wonder if someone can help me finding the right function. I have a worksheet over dates. The left columns contains dates (my input) and the right column contains a function A1+15, A2+15 and so on, dates 15 days forward. Now I want Excel to help me find the dates (in the right column) that has passed. Is there a function for this? For example making the date red or fat. Thanks! /Michaela |
#4
|
|||
|
|||
Mark date that has passed
Conditional Formatting (look it up in Excel help).
-- David Biddulph "Michaela" wrote in message ... Hi! I wonder if someone can help me finding the right function. I have a worksheet over dates. The left columns contains dates (my input) and the right column contains a function A1+15, A2+15 and so on, dates 15 days forward. Now I want Excel to help me find the dates (in the right column) that has passed. Is there a function for this? For example making the date red or fat. Thanks! /Michaela |
#5
|
|||
|
|||
Mark date that has passed
Or Format / Conditional Formatting / Cell Value is / Less than / =TODAY()
-- David Biddulph "Ashish Mathur" wrote in message ... Hi, In column cell B1, enter the following formula in Format Conditional Formatting Formula is =TODAY()-$B10 Select the desired font. -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Michaela" wrote in message ... Hi! I wonder if someone can help me finding the right function. I have a worksheet over dates. The left columns contains dates (my input) and the right column contains a function A1+15, A2+15 and so on, dates 15 days forward. Now I want Excel to help me find the dates (in the right column) that has passed. Is there a function for this? For example making the date red or fat. Thanks! /Michaela |
#6
|
|||
|
|||
Mark date that has passed
Thank you all for your help!!
Kind regards Michaela "David Biddulph" skrev: Conditional Formatting (look it up in Excel help). -- David Biddulph "Michaela" wrote in message ... Hi! I wonder if someone can help me finding the right function. I have a worksheet over dates. The left columns contains dates (my input) and the right column contains a function A1+15, A2+15 and so on, dates 15 days forward. Now I want Excel to help me find the dates (in the right column) that has passed. Is there a function for this? For example making the date red or fat. Thanks! /Michaela |
Thread Tools | |
Display Modes | |
|
|