Over 1 million tech questions and answers.

Excel/Highlight Row Based on Date

Q: Excel/Highlight Row Based on Date

I am trying to create a code that will highlight an entire row the day before the date entered into a cell on that row.

RELEVANCY SCORE 200
Preferred Solution: Excel/Highlight Row Based on Date

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel/Highlight Row Based on Date

use conditional format
add a formula

=cell with the date = today()+1
that will be true if the date

just to make sure we understand

today() is 7th August
the date in the cell is 8th august
so you want it highlighted

so cell = 8th
today + 1 = 8th
it highlights

now to highlight the row
use a $ on the cell that has the date and apply to the whole row

so if the date is in column C and say row 5

then
$C5 = today()+1

in the conditional format formula and apply to
$A$5:$Z$5
or whatever column you need

a sample spreadsheet would be useful , you can attach here

Read other 1 answers
RELEVANCY SCORE 74.4

Alright this one might be a bit of a challenge. I am releasing a complex spreadsheet with my product pricing on it. Is there a way to make the program have a "shelf life" of 6 months or so? I would like to set it up to make it inaccessible to anyone without the password after a certain time period. So basically I would like to create a macro that will disable the entire spreadsheet (without the password) after a specific date so I can release new versions (with the new pricing) without the old versions (old prices) getting thrown into the mix. Anyone have any ideas?? Thanks.
 

A:Excel Macro - Date Based Protection

Hello CWDENVER, this should be possible to achieve, you can have a date held in a cell in a hidden Protected sheet in the workbook. When the System date = the date in the Cell the Target Worksheet is hidden and can only be made un-hidden by entering a password.
To be effective the Menus would need to Removed from the Workbook as well.
The VBA Editor would need to be password protected as well.
 

Read other 2 answers
RELEVANCY SCORE 73.6

Hi all,

I would like to conditionally format the attached spreadsheet so that each alternating week is shaded on whole set of rows.

Also with our roster the week runs Thurs to Wed.

I've looked quite a bit into conditional formatting now. But this one has me stumped.

Thanks for any advice.
 

A:Excel: Format rows based on date and a few other specifics

Read other 7 answers
RELEVANCY SCORE 73.6

I'm looking for a simple way to have an email sent automatically 60 days within a date on an Excel spreadsheet
 

Read other answers
RELEVANCY SCORE 73.6

Dear Friends,

I'm in a serious need of updating the respective teams with reminders on due dates of statutory compliance requirements. I've developed an excel workbook having three sheets namely Permissions, Returns and Records. All the three sheets are having due dates. (Workbook is attached for your solution please)

I need your expert solution in sending an e- mail message as a reminder to the person concerned before 15 days of due date with an optional text of my choice.

Its not possible for me to open neither the excel sheet nor the ms outlook application on a time basis coz my profile mostly deals with Industrial Relations aspects. Hence I've to be in the field 12/7 during the shift period and on call 24/7.

Awaiting early reverts.

Regards,

SNU.
 

Read other answers
RELEVANCY SCORE 73.6

I have a personnel tracker that tracks required documents that need to be renewed every year. There are 4 of these and each has a seperate column for each date. They are J,L,T and U.

I would like excel to scan each of these columns every time the document is opened for any of those dates that are 60-65 days from expiring, I use Now()-300 to check this.

But if the cell is blank I want it ignored, which right now it does not. If it finds 1 or even 80 that are in that range I want 1 email generated to a list of management personnel.

Currently it generates how ever many are blank or expiring. I use outlook.

My data starts on row 3 and goes down to 331, the required and maximum number of people allowed on the contract.

If I can get just one email with a generic message I would be happy. But if I could I would like the info that is actually doing the triggering to be copied and pasted in the email to include the info in A, C and D.

Here is my current code, I would change .display to .send once I have it working. please help.

Private Sub Workbook_Open()
Dim Cell As Range
Dim DateRng As Range
Dim Msg As String
Dim olApp As Object
Dim olEmail As Object
Dim RngEnd As Range
Dim Wks As Worksheet

Set Wks = Worksheets("Work Site Info")

Set DateRng = Wks.Range("J3")
Set RngEnd = Wks.Range("J331")
Set DateRng = IIf(RngEnd.Row < DateRng.Row, DateRng, Wks.Range(DateRng, RngEnd))

'Change this to what you want.
Msg = "This is message is the bo... Read more

A:Solved: Automatic email from excel based on date

Read other 16 answers
RELEVANCY SCORE 73.6

Hello,

I have seen posts similar to my requests but have been unable to put together a code to do everything I need it to do as I am very new to VBA coding.

I am looking for a VBA code that will generate an email when the date in a cell of a column is 7 days or less from the current date. The email will be sent to a recipient listed in another cell column and cc my coworker. I also need a code to change the data in another cell to "Approve, Email Sent" when the same cell date is between 7 and 1 days from the current date and "Expired, Email Sent" when the date equals the current date so that an email will only send if this cell does not equal "Approved, Email Sent" or "Expired, Email Sent" so that emails are not repeatedly sent every time the spreadsheet is opened. I plan on running task scheduler to open the spreadsheet every Monday so the code will run weekly at minimum.

Any help is greatly appreciated, thank you!
 

Read other answers
RELEVANCY SCORE 73.6

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-a...s-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

A:Automatic Email from Excel based on Date in Cell

Read other 16 answers
RELEVANCY SCORE 73.6

I've read the previous post with the same issue, but I'm unable to understand how to use the other codes posted within my product. I would like to send an email based on a date. I will attach my document so it is easier for me to explain the requirement. Columns L37-L45 have due dates - I would like the email to be sent 60 days prior. I have posted some mock emails in R37-R45 and the email message in the EMAIL workbook tab. Any assistance would be greatly appreciated.

Thank you so much!
 

A:Auto send an email based on date in Excel

Welcome to the board.
I've had to save it as 2003 version but the code works under 2007

See attached my copy of your sheet with the code in ThisWorksheet module.

This just a simple way of doing it and you will have to edit it for your needs but maybe it can put you on the right track.
 

Read other 2 answers
RELEVANCY SCORE 73.6

Hi Everyone!! This is my first post here. I need your help in developing a method of sending automated emails on Gmail when the due date of Insurance payment is 7 days before the current date and an email when the due date has expired.

So as per the attached excel file an email should go to (Col H) when due date (Col F) is 7 days before current date, with the message "Payment of Rs. (Col E) is due for Policy Number (Col D), (Policy name (Col C)) for (Owner name (Col B))"

I have searched through various forums for similar problems but could not really find a solution, as I am not proficient with VBA to tweak the code as per my needs.

Any help would be really appreciated!

Thanks
 

Read other answers
RELEVANCY SCORE 72.8

HI, Its my first post here. I need to send reminder mails from outlook based on excel reminder dates.
For this i should not open excel neither i know VBA scritping for this.
Please provide help on this.
As i attached my file i need list of assets need to be calibrated ahead of 45 days of calibration due date.
 

Read other answers
RELEVANCY SCORE 72.8

Dear All,

I am creating a tracker file for Purchase Orders in which end date in column 'J' is very important.
Column 'J' has following conditional formatting
1. If cell date is in between todays date + 14 days --- YELLOW
2. cell date <= today's date ------------------------- RED
3. cell valus > today + 14 days ---------------------- GREEN

So now when the cell turn Yellow I want the excel should send the mail to the concerned person whose mail id will be mentioned in same row of column 'G'

One more requirement there should be two mails. Reminder 1 & Reminder 2.

I use officer 2010 & mail is outlook 2010 & OS is windows 7.
This file will be on share point. This file may not be opened everyday.

Please reply with the procedure as I am not a programming/ IT person... I may not understand all terms.. please try to simplify the response.
Thanks in advance for all the help.
 

A:Auto mail from Excel to Outlook based on date in cell

Hi there, welcome to the board!

You'd want a location to mark when an email was sent. I'm assuming you want a worksheet change event for this, which will basically always run when a cell on this specific worksheet is changed. There are other events you could use to fire it off, like the calculate event. You could, if you wanted to, assign this functionality to a button, but then it wouldn't be automatic.

The below code does what you ask. It goes in the worksheet module of the worksheet your data is on. To get to it, right click the sheet tab name and select 'View Code', then paste this there.

EDIT: The locations to mark when an email was sent (btw) were columns K and L, as you'll see them set as constants at the top of the code. You can change those letters to any column you want to house it in. It just puts the current system date in those cells, and that will be checked when the values in column J are checked. If nothing is there it assumes an email hasn't been generated yet and will do so. But if it has a value - any value, it will ignore that row.

Also, I assumed a 'yellow' highlighted value was your first reminder, and a 'red' highlighted value was your second reminder. It uses this as text in the subject and body of the email.
Code:
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

Const ReminderOne As String = "K" 'column letter
Const ReminderTwo As S... Read more

Read other 1 answers
RELEVANCY SCORE 72.8

Hello experts

I have an excel document with many sheets starting with sheet2

*** column_headers "enquiry#" in B6 and query_expiry_date in E6 (of every sheet)

What I am looking to do is, using sheet1 (which is unused at the moment)
dynamically return 3 pieces of information (in 3 columns, A,B,C for example)
based on expiry dates.

ie: if the expiry_date<today() then return sheet#, enquiry# and the date that expired.
this is for each enquiry and each sheet and if I can sort them in order of expiry date, that will be owsome.
Can that be done using lookup? or maybe better in VBA? a push in right direction or example
of code snippet is well appreciated.
Thank you
 

A:Solved: excel(VBA) returns data based on expiry date

Read other 12 answers
RELEVANCY SCORE 72.8

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

A:Automatic Email Reminder from Excel based on Date in Cell

Please do not post duplicate threads.
One thread per issue.
Continue replies for this issue in this thread: http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
Thank you.

Closing thread.
 

Read other 1 answers
RELEVANCY SCORE 72

Our employees can sell such things as vacation time, for example, 1 day of vacation pay but their request must be submitted by a certain time if they are to be paid. We can tell them what day they will be paid based on the date they submit their request. This can be confusing for a supervisor to explain and I wanted to automate it on an Excel sheet.
Example:
1. Employees receive their regular check every Friday as well as a check for any time sold.
2. As long as they get it into us within 7 days prior to Friday they will receive their check the next Friday.
3. If itís greater than 7 days then it would be the Friday after next before they received the sold time check.
4. For example If an employee requested on May, 12th 13th, 14th, 15th, 16th, or 17th to sell vacation time that check would be received by the next Friday i.e. May 25th. However, if they turned it in on May 18th. 19th. 20th, 21st, 22nd., 23nd, or 24th. they would receive it on June 1st.
5. This pattern continues throughout the year. Note that weekends are included.
6. I think the attached will better explain what I am trying to do.
 

A:Formula in Excel for a Date to Remain Constant Based on a Range of Dates

I think there is something wrong in the way you explain it but, could be my interpretation though
I adden a column using the Days360() function which shows the nr of days between the request date and the 'friday' date, maybe you can use that resulty to compute the new value.
 

Read other 2 answers
RELEVANCY SCORE 72

Hello all,

I'm receiving mail alert based on date only, it is not considering the month into the account.. Kindly suggest..

Attached the excel file with macro...
 

A:Automatic Outlook mail due date reminder based on Excel file

Read other 16 answers
RELEVANCY SCORE 72

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a payment is 10 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. Q), with subject "Vendor Payment (Col. C) is due on Due date(Col. M)", and body "Dear Name(Col. P), please update the payment status".

Also, the script should put a check mark on Reminder sent column (Col. Q) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scored the forum for similar problems, and although I found a number of threads, I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

A:Automatic Outlook mail due date reminder based on Excel file

Read other 15 answers
RELEVANCY SCORE 72

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is 7 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. D), with subject "Project (Col. B) is due on Due date(Col. C)", and body "Dear Name(Col. A), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. E) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

A:Automatic Outlook mail due date reminder based on Excel file

Read other 8 answers
RELEVANCY SCORE 70.4

I have a spreadsheet that shows all of the upcoming events at my work (I've attached a very basic example of the way the spreadsheet is set out).

When an event passes, I'd like the spreadsheet to automatically change the formatting of the rows that contain events that have already passed.

For example, today being 14.12.09, an event for yesterday (13.12.09) would be highlighted in red to show that the day has passed.

If anyone can provide any detail on how to achieve this, I would greatly appreciate it.
 

A:Solved: Conditional Formatting Based On Date Range In Microsoft Office Excel 2007

Select your data, then Format > Conditional Formatting.

Condition 1; Formula is:

=$A5<$D$2

Click Format > Patterns > red colour > OK.

Click OK.
 

Read other 2 answers
RELEVANCY SCORE 66

Good day,

I was looking for someone to help me in this:

Please see the attached excel file, which automates Groupwise mails for due date reminder. However, it generates individual mails for each due items, whereas, I want one single mail with all due dates. How do I achieve it?
 

Read other answers
RELEVANCY SCORE 66

Hi ! This refers to the subject of "Automatic email from excel based on date", and relevant thread http://forums.techguy.org/business-applications/927675-solved-automatic-email-excel-based.html

This was fantastic. Only one issue remaining.
This is generating multiple emails and even the items not due are generating blank mails.
I would like to generate only one mail with different items different expiration dates.
After that group the identical addressees and compose one message with all the relevant data.
Awaiting kind help.
 

A:Need Help reg "Automatic email from excel based on date "

Read other 7 answers
RELEVANCY SCORE 64

Hi,

I searched the forum but could not find what I am looking for.

Selection for row that contains either apple or banana
I have an excel (2007) with around 45k rows. I need to highlight entire rows based on the value in 'Item' column. If the row has either 'apple' or 'banana' in column A, the entire row should get highlighted.

Now i did try the conditional formatting -> new rule -> use a formula to determine which cells to format and it worked fine for a single value defined. However i want to input more than one value and all the rows with either of the values should get highlighted. is it possible? I have attached a sample file here.
Selection for row which contains 2014
Secondly, if the row has 2014 in one of the colums, say D (like in the sample sheet), the row should get highlighted. I am not using it with the above formatting i..e with apple/banana highlighting. This is for a separate task.

however i made both table in a single file (which is attached).
 

A:Solved: Highlight entire row based on 2 values

Read other 11 answers
RELEVANCY SCORE 56.4

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

A:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

Read other 16 answers
RELEVANCY SCORE 56.4

Hi All

I want to change the color of a cell when it is highlighted or selected. i don't want to change the background color of the cell. does any one know how to do this? I've searched the menu's and have cum up stumped. Maybe there is a rule i could insert in to the page.

Thanks Chris
 

A:Excel highlight color

Read other 7 answers
RELEVANCY SCORE 56.4

I'm working on a spreadsheet that lists monthly recurring expenses. I have one cell on the sheet listing the current date (using the "=Now()" formula), but I'd like to have the other cells change at certain times throughout the month.

For example, if one cell currently says "April-15", when the actual date reads "April-16", the respective cell would change to "June-15". This way, whenever the spreadsheet is viewed the next recurring payment date will be seen.

I know this is the wrong tool for something like this - I'm using SharePoint at the office with a calendar list with workflows that shoot off emails in a much better put together format - but this is just for home use and I'd like to keep it all in one document if possible.

Any ideas or suggestions would be greatly appreciated. Thanks in advance.
 

A:Excel 2010: Cell Date Change with Current Date

The way I read it was that you have fixed recurring payment dates, so you just want to know the next date based on the day today. Hope the attached might assist.
You need to list the payment dates somewhere and then the formula looks up the next date. You might want to look up today plus 1 (or something) to reflect the fact that if the next payment date is today, there's a good chance you'll not get any unplanned payments on that run.
 

Read other 1 answers
RELEVANCY SCORE 56

Hey guys and gals,

Here's what I'm trying to do: I have an Excel spread sheet with 3 columns and many rows depending on the data. I need to be able to search the data in column C for about 10 or so words and highlight them. The problem is, the words in column C have been exported by a program so each word ends with a comma then the next word begins with no space so it's difficult to search. Example, Text1,Text2,Text3 and so on. Is there a macro or software that I can use that will search all the rows for column C and highlight the group of words I choose? I'm using Excel 2007.

Thanks for your help!
 

A:Excel Macro to highlight words?

Read other 7 answers
RELEVANCY SCORE 56

Is there a way to automatically highlight subtotal rows? Without going through each one?

Using excel 2010.

Thanks
Carla
 

A:Excel Subtotals Highlight Automatically?

As far as I know not directly

And there is no need to shout

I haven't come across this myself.
Did you inster the subtotal formula yourself?
If so, you could use Conditional formatting to check if the cell is a formula for the subtotals
 

Read other 1 answers
RELEVANCY SCORE 55.6

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

A:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

Read other 3 answers
RELEVANCY SCORE 55.6

Hello, I have spreadsheet with a number of dates and times ie (11/19/07 8:57 AM) in column A and data going along with each of these dates and times from columns B-CK. I am trying to limit the list to show the information that is for all times after 2:45PM. The problem is I cannot sort by time and the dates attached to all the times span from 2004-2007. Please help!
 

A:Stripping the date portion of date/time in excel

Read other 7 answers
RELEVANCY SCORE 55.6

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?
 

A:Excel 2007 - Start Date and End date question

Read other 16 answers
RELEVANCY SCORE 55.6

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?
 

A:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here: http://forums.techguy.org/16-business-applications/
 

Read other 3 answers
RELEVANCY SCORE 55.6

I have a file that lists a Julian date of, for instance, 37573. How do I convert that into something like 11/06/02?

Thanks in advance!
 

A:Julian Date--How to convert to calendar date in Excel

That's not a Julian date, Beth.

That is actually a date value that Excel provides.

That's how many days it's been since 1/1/1900.

To change it to a real date, you should be able to select that cell or entire column, hit Format-Cell, Number tab, and choose Date, and then any one of the date formats.

Julian dates are what numbered day of the year. For instance, January 3, 2002 would be 3.

Learn lots about dates and times in Excel:

http://www.cpearson.com/excel/datetime.htm

Be prepared to be there for a while.

Happy Thanksgiving!
 

Read other 2 answers
RELEVANCY SCORE 55.6

I am looking to set up a macro or formula that basically inserts the current time when a cell is filled SO:

when a2:a100 is populated with any thing then the corresponding C cell will be populated with the time.

AND

when e2:e1000 is populated wiith anything then the corresponding D Cell will be populated.

Currently I am using this macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A6:A100")) Is Nothing Then
With Target(1, 4)
.Value = Time
.EntireColumn.AutoFit
End With
End If
End Sub

which works great for the A and C cells

but it does not work for the other one.. how do i add and modify this so all my needs are met.
I need another 2 sets of 2 macros accross the sheet for time entry.
 

A:Excel date auto populate date/time

Read other 11 answers
RELEVANCY SCORE 55.6

Excel 2013 and Windows 10 Pro

Today is May-14

Date format is set to show: Mar-16
Pressing Ctrl+; shows: 05 14 2016 in the cell
and it converts to: May-16 after I exit that cell.

Any ideas as to how to fix this or why it adds 2 days to the date?

I don't do much on computer now because of health but when I do and there is a problem, I know some of the experts are here.

Thank you in advance, Ron
 

A:Excel Date shortcut posts proper date and then changes

Hey Ron,

This should be a fairly simple one. I'd hazard a guess and say the May-16 is the month and year rather than the month and day.
If you click the format drop down as shown below, and click the last option for more formatting options.

In the box that pops up, navigate to Custom using the left hand panel to navigate.
Here you can make your own (or use a preset if you wish) format to suit your needs.

Here is a quick key to help you get by:
dd = Day in Number format
ddd = Day in Short text
dddd = Day in Long text
mm = Month in Number format
mmm = Month in Short text
mmmm = Month in Long text
yy = year in 2 digits
yyyy = year in 4 digits

You can separate these with pretty much whatever you want.
All of this data is input into the "Type" field as shown in the picture above.

See the picture for an example, Ironically it is May 16th today so it will appear the same as your issue does, but rest assured, as long as you have those D's in there, it will display the day!

Best of luck,
Let us know how you get on,

Xsage
 

Read other 1 answers
RELEVANCY SCORE 55.6

Hiyo.
To begin with, I just want to check if this is viable, and if so, which solution is best/easiest...

Office 2010.

Current situation:
An Outlook rule moves certain messages to an Outlook folder.
A macro button is used to run code that prints the attachments of all messages in that folder.
Think it then deletes the messages.

Required situation:
Instead of printing all attatchments, the macro needs to look at a specific column of data in an Excel file.
If a value in the Excel column matches (or part matches) the filename of the attachment, the attachment is printed.
All attachments with filenames that do not match the Excel list are left alone.

Alternatively, switch it round, so the macro is in the Excel file, and it checks the values in the column against the attachment filenames of messages in that Outlook directory, and prints those that match.

Alternatively, write something in Outlook code, perhaps using a form control, whereby the user can enter (paste in) the batch of values, and it then prints attachments accordingly, rather than trying to forge a link between Excel and Outlook.

Alternatively... use some 3rd party tool that accepts the batch of values and interacts with Outlook to print the attachments, bypassing the need to write and manage code.

Or something else?

Cheers.
 

A:Outlook/Excel - Print selected attachments based on Excel list

Alternatively... modify the existing Outlook macro to save all attachments to a dir on the PC instead of print, and then write an Excel macro to check the files in the dir instead of the Outlook folder.
 

Read other 1 answers
RELEVANCY SCORE 55.2

Hallo,
I'd like to set up a macro, whereby I can enter two lists of chassis numbers and compare them, so it will identify all of the numbers in list A that do not appear in list B, and all of the numbers in list B that do not appear in list A.

So, my lists may look like:
List A - List B
A123 - A123
A124 - A124
A125 - A126
A126 - A127
B555 - B555
B557 - B556
B558 - B559

So, I need to highlight A125 in List A and B556 in List B.
List A - List B
A123 - A123
A124 - A124
A125 - A126
A126 - A127
B555 - B555
B557 - B556
B558 - B559

Is there a simple way to do this?

I've been messing around trying to find a way to do this quickly - I tried colouring each list in a different colour and then using the "Unique Records" filter, but it didn't seem to work correctly.

Ta
Gram
 

A:Excel - compare 2 lists & highlight differences

"Conditional Formatting"

This will do exactly what you want.

Hope that helps,

Drew
 

Read other 3 answers
RELEVANCY SCORE 55.2

This may be an easy one; I searched but couldn't find it.

I have a project name sheet1 in a workbook with a column of hyperlinks to the right of each project. When clicked, it highlights the cell in sheet 2 with the notes for that project.
I would like to make all the text on the notes sheet white, and when a cell is highlighted, have the font be a different color only then.
In other words, I need a way to make the highlighted (linked) cell stand-out from the page.
Sorry if this is really simple; I just can't figure out how to do it.
Thanks in advance.
 

A:Excel Text Cell Highlight Question

Read other 16 answers
RELEVANCY SCORE 55.2

I have 2 worksheets. the main worksheet that I want to have the conditional formatting on has a connection to an Access database. I want to take this worksheet and have it compare to another worksheet in the same workbook. I am comparing cell to cell. Example - D5 on each page. But I have many cells to compare. I would like to have the highlights happen on the connected worksheet, but I am not sure if that is possible. There are 13 columns and 880 rows to conditional format

I have created a 3rd worksheet that uses =ISNA(MATCH(Summary!E5,'Last Summary'!E5,0)) to get some true false results. but I still cannot seem to get it incorporate into the main connected worksheet.
 

Read other answers
RELEVANCY SCORE 55.2

This is a reopening of another thread. I still have not found any answers that help. And we won't discuss the lack of support from MS.

I am running Windows XP, Excel 2007.

I have noticed the problem with extremely light shading in xp-excel. It makes things especially difficult when selecting multiple, remote cells or text using the 'ctrl' function, as you cannot see which section has been highlighted or not (note, many people do not understand the nature of the problem as when selecting one cell/group of cells there is a box around the selection, making it easier to visualise, however in selecting many cells, there are no boxes to assist).

I work with spreadsheets constantly and need to highlight for deleting purposes and this is giving me headaches, etc.

Thank you.
 

A:Solved: Excel Selection highlight color

Read other 16 answers
RELEVANCY SCORE 55.2

I know this is probably very simple, and I am going to hit myself once the answer is found, but I cannot seem to think of the solution for the question below.

I need to highlight all the cells in a column that does not contain a zero. How would I go about doing this with code?
 

A:Solved: Excel Macro - Highlight Certain Cells

Read other 9 answers
RELEVANCY SCORE 55.2

Yes, can anyone help me figure out how to use the Find and Replace command (Ctrl-F) in excel to highlight the cells that's been found in yellow or any color.

Sometimes, I would have to verify and match serial numbers from a hardcopy and file that was sent to me. It would be great (and would make life easier) if I could have excel or the Find and Replace command to automatically highlight each cell that is found. Thanks
 

A:Excel: Highlight Find/Search Cells

Read other 11 answers
RELEVANCY SCORE 55.2

Hello,
I have a large spreadsheet that has dynamic cells being fed by a pricing engine. I need to monitor when a price changes. How can i make the cell highlight everytime a price ticks so that i can immediately see the change.

regards,
 

A:highlight dynamic cells when they tick in excel

can you upload a dummy set of data
what do you mean by
price ticks

have a look at conditional formatting
 

Read other 2 answers
RELEVANCY SCORE 54.8

Daily we send many mails. We handle the reactions of customers which send us a mail using our subject the first 7 days (not a reply). After 7 days we would like to send an autoreply and archive the mail without looking at it.
How can we do that?
As we can adapt the subject to use, first idea was to add the limit-date and set a rule. But I don't find how to set a rule that compares the day of reception and this date included in the subject?
 

Read other answers
RELEVANCY SCORE 54.8

I have added some bookmarks earlier (have already many bookmarks) but I just can't find them and was wondering if it Is it possible to search for the bookmarks based on the date it has been added to the browser?
Just like opening windows explorer and you can search base on dates, file size or the name.
 
thanks in advance
 
 

A:Possible to search bookmarks based on date?

You did not say which browser but for firefox go to Bookmarks > Organize Bookmards.  In the Bookmarks Window select Views > Show Columns. Check Added for the date added.
 
Edit: I don't think you can search by date though. You can only sort by date by clicking on the Date Added heading.

Read other 5 answers
RELEVANCY SCORE 54.8

I want to Highlight Multiple Values with an Excel Macro. I want the macro to loop though and grab the list/range of values from another sheet and use it in the Array.

I want to avoid having to enter such a big list of values for the Array. I want to use something like "SearchVal() = Range("Lists!A2:A62").Value" but I get an "out of range" error. Here is my code now.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Sub Highlight()
Dim SearchVal() As Variant
SearchVal() = Array("ALM", "AXV", "AZZ", "BCT", "BHN", "CRE", "CSI", "CVM", "DCH", "DEK", "DER", "ESE", "GCV", "HCO", "HND", "HSI",
"IBO", "ILW", "KCM", "LEO", "LES", "LPA", "MCY", "MEX", "MHS", "MRM", "MSL", "NCL", "NTX", "NZI", "PHC", "PLA", "PPH", "PSE", "PUV",
"PVN", "PWL", "RKC", "RSN", "SCM", "SEL", "SGA", "SHC", "SRG", "SVL", "SYV", "TGC", "THA", "TSL", "VAV", "VID", "VTA", "WHE", "WHH",
"WIH", "WWJ&qu... Read more

A:Solved: Highlight Multiple Values with an Excel Macro

Read other 8 answers
RELEVANCY SCORE 54.8

Hello,

As per the title I want to compare the data between two excel files not work sheets in the same file (if that males a difference).

So I want to compare the old data with the new data and highlight the differences in red or any color on the new sheet.

Thanks!
 

A:Compare data in two excel WORKBOOKS and highlight difference

Read other 12 answers