Highlighting Cell When Enter Specific Date In Another Cell
Jul 4, 2013
I have a problem regarding highlighting a specific cell, when i entered a specific date in another cell
Let me explain
If there is a Name, joining date, termination date/resignation date in cell A1 A2 & A3 respectively.
If the name is John, Joining date = 01/01/2012, Resignation Date 06/06/13
I need a formula which highlights the cell A2 plus all those cells which have the same date when i entered a date (i.e 01/01/2012) in another cell.
View 2 Replies
ADVERTISEMENT
Jul 10, 2006
I have 6 Headings in excel named...
"A" in cell A1, B in B1, "C" in C1, "D" in D1, "E" in E1 and "F" in F1.
There are two projects.
Project 1 has phase A, D & F and Project 2 has phase A, B, C, D & E.
My Specification follows...
1). Take Prject 1 - Which starts from A...in cell A2 I will keyin "A". When the phase comes to an end I will key in the end date of the phase. As soon as I key in the end date in cell A2 Letter D should automatically appear in the cell D2 and when Phase D comes to an end I will key in the end date in Cell D2 which should automatically keyin F in the cell F2. and is the same case for Project 2.
View 3 Replies
View Related
May 29, 2013
I want to enter the word 'Closed' in cell B1 when the due date in cell A1 is exceeded by 272 days. I have tried using conditional formatting and excel accepts the formula but nothing seems to happen. Here is what I have tried;
B1=IF(A1<=NOW()-272,"Closed")
View 4 Replies
View Related
Aug 13, 2008
I have Excel 2000, recently when I format a cell to display mm/dd/yyyy and enter mm/dd/yy, it is displaying dd/mm/yyyy. Or it starts out correctly and during a future opening of file it displays incorrectly.
View 2 Replies
View Related
Feb 3, 2014
I need to add something to the code below to have my first row of data entered into cell "Q8". As it is now the data is starting on row Q9 instead of Q8, but the rest of it is filling in correctly.
[Code] .....
View 1 Replies
View Related
Jul 31, 2014
I have to enter a ton of dates in cells that don't need to include the day. And so was hoping if there was a way to enter a date into a cell without having to enter the day.
In essence, it seems like I have to type in the date as month/day/year and excel will figure it out from there. I would like to be able to just type month/year without bothering with the day, such as 9/14. And then excel recognizes this as a date.
Excel has to be able to recognize it as a date because these dates are expiration dates. And I would like to conditional format these dates so that when the expiration date has past the cell turns yellow.
View 10 Replies
View Related
Jan 25, 2007
when the number in cell 'A1' reaches zero i want the VBA code to enter the date in cell 'A2' that it became '0'.
This is as far as i've got.
Dim keyRange3 As Range
Set keyRange3 = Range("L:L")
If Not Intersect(keyRange3, Target) Is "0"
Target.Offset(0, 2) = Time
End If
View 9 Replies
View Related
Nov 20, 2013
I have a spreadsheet that contains data from sales being made in various locations (sheet 1). The date the sale was made is in column A, and the location is in column AZ. I may have from 0 to 12 sales at that location on the same date. I am building a report in another sheet (sheet 2) that counts the number of sales for each date and displays that number in a cell in row 3. Above row 3, I want a formula that will reference the location (AZ sheet 1) and display that into my cell above row 3 in sheet 2. Each column in row 1 sheet 2 will have new date.
View 5 Replies
View Related
Jan 21, 2008
I know there is a way to enter the current date in a cell.
But
Is there a way to prevent the previous dates enters from updating to the current dates evey day?
View 9 Replies
View Related
May 9, 2008
is there a formula that will find a word in a sentence written in a cell and if present then enter specif text in another cell? for example, if the word "Hotel" appears in the sentence in cell A5 then put in the text "Hotel and subsistence" in cell B5...
View 2 Replies
View Related
Aug 20, 2013
I am attempting to enter a code for the current date (m/d/yyyy). For appearance purposes only on the form I am using,
I am trying to enter spaces between the numerals. (" "&m&" "," "&d&" "," "&yyyy&" ".
I can only get the serial numbers to come up, no matter how I try to format the cell.
View 6 Replies
View Related
Aug 21, 2009
I have two sheets - Data and Mail.
I am using a userform to collate the information in the "data" sheet and have a unique ref number in column A. Data populates columns A - AC.
In sheet "Mail" I enter the Ref number and it pulls through the info using vlookups into a template which I then e-mail as the body of the text on the click of a macro button.
I wish to capture the date each time the button is clicked in the same data row starting in column AD then AE etc.
I have cobbled all of this together by searching around this forum - I have not expertise so please be gentle with me!
View 9 Replies
View Related
Aug 19, 2013
I have used data validation to colour rows in one of my spreadsheets at work. The column that uses the data validation is the first column and has a drop down list of 5 words. One of which is collected, which currently indicates when the card has been collected by the individual in question and no further attention is required. It colours the rest of the row green. There is also a column that is entitled 'Date Collected'. Instead of having to input this manually, is there a way to automatically enter the date to be the date that the 'Collected' value was selected?
The title is misleading, I realise there will need to be some sort of IF statement in the 'Date Collected' column. It's been a long day already.
View 6 Replies
View Related
Nov 15, 2006
I have a spreadsheet in which I want to track the date and time someone made an entry in an adjacent cell (so if someone enters something in B2, I want the date/time of that cell edit to appear in C2).
When the date/time has appeared, I want it to remain the same and not update when the worksheet is opened the next time. So I can't use NOW to pull it in, because that's going to change every time the file is opened.
View 2 Replies
View Related
Jun 21, 2009
I have this userform:
DATE : [TextBox1] WITHDRAWAL: [TextBox2]
[Commandbutton1]
In my sheet I have a list of all the days in a year in the cell range of AJ12:AJ376.
Basically I want to find the date in Textbox1 within the range of AJ12:AJ376 and enter the value of Textbox2 in a adjacent cell. The adjacent cell would be in column AT. This would be achieved hopefully via a code using the commandbutton.
View 9 Replies
View Related
Nov 12, 2013
I would like to know how to use a VBA code to insert today's date into a specific cell (B9) when any cell in column B (B2:B8) has changed.
View 3 Replies
View Related
Sep 28, 2011
I am trying to date stamp a cell when another cell has been changed from a drop down selection list. For instance: If cell A1 is changed, time stamp B1. I have tried both the following codes and they both work for 1 column.
"Private Sub Worksheet_Change(ByVal target As Range)
If target.column = 1 Then Cells(target.Row, 2) = Now()
End Sub"
[Code]....
The problem is that I want to time stamp cells in columns FHJLN, when the column to the left has been modified (EGIKM). So I basically want to repeat the time stamp code for multiple columns. I have tried messing around and can get not more than 2 columns to work at a time.
View 3 Replies
View Related
Feb 28, 2014
If a cell has a date in it (date payment received) I would like to replace it with the value of the payment received that is given in a different cell - how do I do it ?
View 2 Replies
View Related
Feb 17, 2010
I have a column for each month where the dates are entered on rows. Is it possible I can color a cell if the date entered in a cell for that month is 15 days past the end of the month. Like, if in a January column I enter a date on one of the rows as Feb.20, then the cell fills with red colour. I tried doing it using conditional formatting, but don't know how to say 15 days past end of the month?
View 5 Replies
View Related
Jan 26, 2012
What I have done is create a macro in Excel and then opened up the VBA editor to make a lot of changes to the initial macro. I am reformatting a whole lot of separate spreadsheets over many workbooks.
Here is the code that is generating the error (Run-Time error '438', Object doesn't support this property or method):
Code:
Range("E2").Select
Selection.Format = "long date"
With Selection
.Font.Size = 11
' .Format = LongDate
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
As you can see, I first tried the ".Format = LongDate" and did put LongDate in "" which did not work, then I tried the "Selection.Format = ..." after the "Range" statement, and that did not work either. So you will actually know, I am trying to set the format for the cell "E2" to a Long Date format.
View 7 Replies
View Related
Jun 25, 2014
I have this formula counting down days until my next fire drill:
[Code].....
However... Every time the drill is done I need to change the date in the formula for the countdown. That I can have it reference a cell instead?
My initial idea was a formula like this:
[Code] .....
(however this code doesn't actually work ...).
View 5 Replies
View Related
Feb 8, 2009
I need the code to add the selected date to a specific cell lets say cell D8
at the moment it adds the date in any cell selected
View 4 Replies
View Related
Dec 14, 2013
Basically, it is a scheduling of approving or rejecting of request dates. whereby, i will receive the request dates from Google doc form and then i will extract the data from web into the excel. The data i receive will include the ID, Date request and Remarks.
With the Information in hand, the data will then be "plot" into a schedule (which is a year calender that i have created on excel) base on the ID requested from the web and the ID in the excel.
After plotting, i also want to check if the number requested date exceed the quota set PER DAY, if it exceed, then i have to reject, if its not then approve.
So here comes the problem.. After all the dates have reflected on the calender, I want to get the information from the calender result(which is whether the date is approve or reject) back on to respective ID and Dates requested.
I have attached a example excel for clearer view of my explanation.
View 6 Replies
View Related
Jan 31, 2014
I have a table that has a number of new starters and corresponding appointments offered, what I originally required was to lookup the chronological date after the new start date.
However this has now been scuppered by my boss who has requested that not only lookup the date, but also add who the appointment is with, but if I do this the first array formula stops working and to tell the trust I'm not to sure how to do it anyway.
View 3 Replies
View Related
Oct 18, 2011
i want to insert the last date written in a cell into a specific cell automatically,
1- Date column is D containing dates from starting of the month
2- A1 is cell in which last date from column D should automatically be inserted.
automatically copy the last entered date in column D and pastes it to cell A1,
View 4 Replies
View Related
Jun 11, 2003
I have created a user form using the addins that come with excel to create a calendar that will allow the user to select a date and automatically put that in a specific cell. My system is office 2000.
The code is as follows:
Private Sub OK_Click()
Dim i As Integer
Dim myCell As Range
i = 0
For Each myCell In Selection
myCell.Value = Calendar1.Value + i
i = i + 1
Next myCell
Unload Me
End Sub
Now, I gave it to my boss who has xp, and I get the following VB error when she chooses a date and clicks on the ok button:
Method 'Value' of object 'ICalendar' Failed
View 9 Replies
View Related
Mar 6, 2007
formula that can automatically use the current month date to extract information from other cells on my spreadsheet.
For example: This formula should be located in cell C6. Cells D6, F6, H6, J6, L6, N6, P6, R6, T6, V6, X6, and Z6 (these cells correspond to the months of the year, January to December respectively) contain the values I need. The month names are labeled above in row five.
Let's say the current month is March, I need the formula in C6 to automatically know that it is the month of March and to pull the information from cell H6 (which is the March cell). Then when April comes along, it will know that it is April and to only pull the information from cell J6; and so on until the end of the year.
View 3 Replies
View Related
Jan 20, 2009
I have number in cell (A1) = 100. when I enter number in any cell of column(B) for example (B1)=10. then in cell (C1) the result of (A1) - (B1) = (90) and if I add in cell (B2)=10 then in cell (C1) the result of (A1) - (B1+B2) = 80 .accumulatively in cell (C1). and any number in column (B), the result will be (A1) minus any number in column(B) accumulated in (C1)
second question
I have number in cell (A1) = 100. when I enter number at cell (B1) = 10 then the result would be in the adjacent cell (C1) = (A1) - ( B1) = 90 and If I enter a new number in cell (B2) = 10 then the result would be in the adjacent cell (C2) = (A1) - (B1+B2) = 80 and If I enter a new number in cell (B3) = 10 then the result would be in the adjacent cell (C3) = (A1) - (B1+B2+B3) = 70 and so on. I want the result to be add automatically to adjacent cell in column (C)
View 3 Replies
View Related
Feb 11, 2009
this seems like such a simple thing to do but I just cannot suus it out. Basically I want to Highlight a cell depending on another cells value:
ie. I have a value in Cell A1 and a value in Cell B1, in Cell C1 I have an IF statement that dsplays the word 'NO' if the values in A1 & B1 are not equal. In Cell D1 I have the word Fault. I would like to highlight Cell D1 if the Cell C1 displays the word 'NO'
View 3 Replies
View Related
Mar 17, 2014
excel.jpg
how to make my network days stop counting when I insert a value in the completed column (in this case H3). I have a Date Received column (A3), a due day column (G3) and the last column with the date (N3). My remaining days column keeps counting after I filled the completed cell (H3) and won't stop counting after. I need a formula to stop after the completed cell is fill up.
View 5 Replies
View Related
