| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark date that has passed
Hi,
Select B1 then Format|Conditional format Formula is enter the formula =AND($A1<"",$B1<TODAY()) 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mark date that has passed
Hi,
In column cell B1, enter the following formula in Format Conditional Formatting Formula is =TODAY()-$B1<0 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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()-$B1<0 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| how do I fix a forecast date that has passed for a zero value? | Excel Discussion (Misc queries) | |||
| IF Formula to calculate whether date has passed | Excel Discussion (Misc queries) | |||
| Date Passed Notification | Excel Discussion (Misc queries) | |||
Linear Mode
