Over 1 million tech questions and answers.

Highlight if cell contains specific year

Q: Highlight if cell contains specific year

How can I automatically highlight a cell if the date contains a specific year?

Conditional formatting only offers yesterday, today, tomorrow, last week, last month, etc.

I have a list of publications with revision dates in subsequent columns (revision date 1, revision date 2, etc.). I need to have all revision dates from 2017 highlighted yellow and dates from 2018 highlighted red.

Thank you!

Preferred Solution: Highlight if cell contains specific year

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: Highlight if cell contains specific year

use your own rules
Are the dates actual dates or Text

for Yellow use
=AND(A2>=DATEVALUE("1/1/17"), A2 <=DATEVALUE("31/12/17"))
for red use
=AND(A2>=DATEVALUE("1/1/18"), A2 <=DATEVALUE("31/12/18"))

for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

Range the dates are in

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:

one of the formulas above

Format? [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

repeat for the other formula

NOTE - if you select the whole column ie A - then use row 1
A1 in the formula

if a range
then use
C5 in the formula

Read other 1 answers

I know there is a way to use css to highlight an entire cell on mouseover rather than just highlighting the text background. The site I'm working on is www.NortonsFineArt.com and that's what I'm trying to do for the nav bar but can't seem to figure it out.
Any thoughts?


A:DWmx highlight cell using css

Have you tried naming the cells and assigning a mouseover funtion to it?

Read other 3 answers

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

In range A2:A11 I have a range of numbers .
What I want is for a CF or code that would find the highest number in that range and hightlight it in say green and also the full row that contains this highest number.

Have tried this CF formula , based on a google search

Result is only cell in column A is highlighted (say A6) and not the whole of row 6.

Any suggestions welcome


A:Solved: Highlight whole row depending on 1 cell ,excel 2003

Read other 7 answers

Filename: SysInfo.exe
Full Path: c:\Users\JIMBO\AppData\Local\Microsoft\Windows\INetCache\IE\RBAGCWGH\SysInfo.exe


Not Available


6/27/2016 at 5:17:31 PM

Last Used
Not Available

Startup Item
Many Users
Thousands of users in the Norton Community have used this file.

This file was released 4 years 8 months ago.

Norton has given this file a good rating.
Source File:

File Thumbprint - SHA:
File Thumbprint - MD5:
Not available

A:excel Today's date (year) - cell date (year

Read other 11 answers

What can I use (formula, etc) to check if a cell has a fill color or not? I have thousands of records with some with a yellow fill color. I need to move those that are filled to another sheet.

A:Solved: Excel: Formula to check cell color highlight?

Read other 8 answers

Good morning,
I want to know how to highlight specific programs in the start menu (eg. when you install a new program). What values ​​do I need to change in the registry?
Thank you very much.

A:How to highlight specific programs in the start menu?

Hi Emanuele and Welcome to the Forum
First off Don't touch the registry unless you know exactly what you are doing!. What do you mean "Highlight the program"?

Read other 2 answers

Hi everybody and greetings from Belgium:
I was wondering if anyone might know if there is any way to get excel to highlight the cells when it finds information I've asked it to via edit>find.
Because I have such big spreadsheets, with a lot of text, and numbers, I find it really hard to see where the "found" cell is.
Thanks in advance

A:Excel 2003, find function, highlight "found" cell?

Read other 7 answers

I need to set up a query that pulls information matching a certain date of the current month and year. I'm not sure about the syntax. Someone help please?

A:Solved: Query for specific date, current month and year.

Read other 16 answers

I think this may be a long shot, but why not ask!

Is there a way to stop whatever Auto-Correct options are set in Excel for a specific cell. To be specific I don't want Excel's "Correct TWo Initial Capitals" option to work for a one specific cell, but its okay to work for any other cell. To go a bit further, the cell I don't want it to work on is a cell that my read into an external database as username that is case sensitive. So, I don't want Excel to automatically turn HSmith to Hsmith.

I know I can just tell my users to be careful for this, but having a solution would be great. I am versed in VBA, so any programming solutions are welcome.

A:Solved: Do Not Auto-Correct on Specific Cell

What about this one:


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then Application.AutoCorrect.TwoInitialCapitals = True
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
Application.AutoCorrect.TwoInitialCapitals = False
Application.AutoCorrect.TwoInitialCapitals = True
End If
End Sub

Read other 2 answers

I sometimes use this bit of code to force Excel to open a workbook on Sheet1, cell A1:

Private Sub: Workbook_Open()
End Sub
This works nicely, but if I had a chart selected in another sheet when I last closed the workbook, when I come to open that sheet, it remains selected. If I wanted to perform a print it then prints the selected item - the chart - to the full size of the paper and misses any other info around it.

I currently have about 100 charts in 10 different Excel workbooks, so I have to be careful to ensure that every chart is unselected when I close the workbooks down.

1) How do I amend the code above to select cell A1 on every worksheet?

2) Can this still be done if the names of the worksheets are different - i.e. does Excel somehow still identify the left-most worksheet as Sheet1 even if it has a different name?

3) And what if the number of worksheets per workbook differs? In some workbooks I have 2 worksheets and in others I have 10 - can I use a standard bit of code that won't error if it runs out of sheets.



A:Excel code to open at specific cell and sheet

Read other 9 answers


I've volunteered to sort some data for someone as part of a project I'm doing. The problem is I'm not too sure how to properly write/use macros for Excel 2007.

The point of the data sorting is to eventually clean up a dataset so that I have the start of an address i.e. 1 North Street City.

I've got a dataset of thousands of values made up of parts of addresses. Some of the data have postcodes already and I want to extract these postcodes as a starting point to clean it up. I'd like to extract them and save them in a separate cell.

So I was wondering if anyone could help?

Say for example I had this data in A1

1 North Street B22 2BC

Is there a way to write a macro that will select any combination of three characters a space and three characters, whether that would be at the start, middle or end of a cell? And then put this data into a neighbouring cell?

If anyone could help I would really appreciate it!



A:Can I search and extract characters from within a cell if they fit a specific pattern

Read other 8 answers

I have an excel sheet which has some data sorted in 5 columns (A,B,C,D,E)

Column D contains a machine name: either COLDTEST1 or COLDTEST2
Column E contains a number

What I want to do is to select the numbers in column E according to the machine name in column D.
So i basically need a command that looks for all the cells in column D that are called COLDTEST1 and select all there corresponding numbers in the cells in column E.

Could someone help me with this please?

I am thinking I would probably need a Do While or a For loop, but since i have limited knowledge in VBA I could not figure it out.

Thank you

A:Solved: Do While/For Loop to find specific cell contents

Read other 13 answers

i have a spreadsheet that updates with data from a number of different sources. i need to filter only the relevant data that i need. i'm almost there but need to find out how to pull 2 more pieces.

in the attached spreadsheet the cells i need are in column R and T. I need to know the corresponding "name" and "size" of the data that is in column S.

unfortnuately the actual values don't show up in the spreadsheet b/c they are live data feeds but the formulas written up until now are still there.

in a nutshell what i'm doing is getting 5 price feeds and i need to filter out which is the highest updated within the last 2 minutes. i actually have the only the price figured out in column S, but i also now which name and how big the size is related to that price.

your help is very appreciated.


A:Solved: excel - data returned based on the value of a specific cell

Read other 10 answers

i do call data analysis in excel 2007 involving more than 1 lac call record.

i need to exctract certain text (eg.Oracle) before a word (eg. install,repair,reload,reinstall) and even after these word if any.

maybe 10 characters before and after the word "PLEASE INSTALL ORACLE"

as in call records we have fields as Problem/Issue raised and Resolved.

Please help..!!!

A:Excel 2007 - Extracting Characters before & after a specific word from a Cell

Hi, welcome to the fourm.

I suggest you write a macro.

In this macro you search for the position you word starts:

You use the Instr() function

Dim pos as integer
pos = instr(1,<your full text string>,<you word>)

"This is your text string and you need to know where the word is"


pos = instr("This is your text string and you need to know where the word is","text")

pos will return the value 14, the beginning position of the word "text"
try this in Excel as macro

Sub test()
MsgBox InStr(1, "This is your text string and you need to know where the word is", "text")
End Sub

After you have the pos value then you can work with the different string functions to extract or create your desired text

Read other 3 answers

Hi guys,

I've attached the dummy file. You see the report groups all the relevant data pertaining to the person's name and puts it under the name of the person. I need a macro that will copy the name of the person in column A across all the rows of data pertaining to the person's name in column Z. I will not know which row the name of the person will be in or how many rows of data each person will have, so the macro needs to search through all the rows to find specific names.You'll see an example of what I need in column AA.

I then wrote a macro just based on reading in the net to remove the blank rows in column A. For example A6 is blank, so the macro I wrote deletes that column. The macro also deletes the "Total No. of Cases" row.

This is the macro:

Sub Deletejunk()
' Deletejunk Macro
' To delete rows containing *No. of Cases* & Blanks
' Keyboard Shortcut: Ctrl+Shift+O

With ActiveSheet
.AutoFilterMode = False
With Range("a1", Range("a" & Rows.Count).End(xlUp))
.AutoFilter 1, "*No. of Cases*", xlOr, ""
On Error Resume Next
End With
.AutoFilterMode = False
End With
End Sub
I would like that after the previous macro copies the names to column Z this macro could run straight after that. Even better if this macro could delete those names in column A. I'm thinking we would then have to make an array of things to... Read more

A:Solved: Macro to copy text from a cell to a column with specific criteria

Read other 8 answers


I need a cell to accept only data that meet the following criteria:
1. the first 9 characters should be composed of numbers only
2. the 10th character should either be a letter or the number zero (0).

If they don't meet both of the requirements, I need for an alert box to pop up informing them of the requirement they failed to meet.

How do I do this?

Is it possible to do this purely with an in-cell formula and formatting/data validation?

A:Solved: How do I format a cell to accept only data that meet specific requirements?

Read other 11 answers

Trying to pull the word "set" from a cell that has more words and characters than just "set. I also need it to account for variables such as lower case/upper case (i.e. SET, SeT, SEt, seT). The formula needs to pull the word "set", however it looks, into the adjacent cell, this way I can use the Sort tool to organize all cells.

I tried the INDEX formula, but it only looks for the word "set" without distinguishing it from the other characters.

I don't think the LEFT/RIGHT/MID functions will work, as the character count is going to be a variable from each cell (my judgment on these formulas is really shallow due to my lack of time to completely understand them).

Take a look at the attached spreadsheet and you'll see where I'm going.

Thanks in advance

A:Solved: Excel 2007 - Formula for Extracting Specific Characters from Cell

Read other 9 answers

HI guys,

I am using Microsoft Excel 2003 and am trying to create a scheduler for my work place.
What I have to do is allow the user to enter data in the input sheet (by input meaning Dates) and then accordingly scan the schedule sheet and find the date entered on the input sheet, following which print the appropriate schedule opposite that date for that particular project.

For Example .....
If a person is working on a project called apple in cell D (effectively making it the 3rd project in the list) and the user enters the project start and end dates as 5th June and 13th June. So what I have to do is scan the Schedule sheet for these dates and enter the appropriate text of Start and End before these dates in the D column (i.e under the respective project).

How to do this I am clueless as I am a complete idiot as far as excel is concerned. SO any idea or any sort of help as to how this can be achieved will help.

The sheet must be automated as far as possible and there are about 25 to 30 projects which need to be updated into the sheet before the final output.

Thanks in advance.

A:Solved: Formula to find a date and enter schedule in a specific cell in Excel

Read other 13 answers

ive never had this problem before. If anyone can help this weird problem id be thankful.

A:cant highlight text on pages cant even highlight in notepad

Change your mouse and try again.

Read other 3 answers

In cell j, I have formula =IF(SUMPRODUCT(ISNUMBER(SEARCH("VLXP",K2:AB2))+0)>=1,"Yes","No") that returns yes or no if VLXP is contained in any cell K2 through AB2 and it works correctly. What I would really like to do is then put into cell j the entire matching cell content or if not found return n/a. Is there a way to accomplish this maybe with VBA?

A:Solved: Excel if cell contains vlxp then put matching cell data in current cell

Read other 6 answers

hi, i have 2-excel cells in the same sheet, both contain manually entered numbers; cell-2 changes frequently; if the existing entry in cell-1 is < than the new entry in cell-2, cell-1 should immediately reflect this new value. how do you create this formula?

A:Solved: excel-replace content of cell-1 if cell-2 is > cell-1

Read other 8 answers

I've read every post I could find on this so I'm sorry to ask another dumb question but here goes.

I created an access database (volunteer work) which has an autoincrement field to issue numbers to animals taken in at our shelter. My 'boss' (also a volunteer) wants this simple autoincrement changed to a value which begins with the two digit year and then has 4 digits, starting with 0001 which will increment sequentially and restart at 0001 with the new calendar year. Therefore, records will start with 10-0001, 10-0002, etc for this year and 11-0001, 11-0002 for next year.

Any help would be greatly appreciated.

A:Autoincrement field including year - restart each year

Read other 16 answers

I have created
C:\00 - savehere \2012
C:\00 - savehere \2013
C:\00 - savehere \2014

current vba code is:-
ChDir "C:\00 - savehere \2012"
Range("c57:h102").ExportAsFixedFormat Type:=xlTypePDF, Filename:=composedfn & ".pdf"
Is there a way to save to ChDir "C:\00 - savehere \ currentyear
without having to change the vba integer value to each new year? or using if statements for each year? So when the 1st of jan comes it automatically save to the new current year directory and if possible creates a directory at the start of each new year as well?

A:Solved: Save PDF to a year directory each new year or month

If folder exist....

' Does this directory exist? If not, create it.
If objFSO.FolderExists(strParentPath) = False Then
Set newFolder = objFSO.CreateFolder(strParentPath)
Wscript.Echo "Put a ocr fold here" &
'Save it here code'
End If

This will get you the year
CurrentDate = Date
File_Year = DatePart("yyyy",CurrentDate)

You should be able to code it with this info

Read other 2 answers

I found a post on this exact topic from back in 2010. I am trying to incorporate the code into my database and am not able to get the code to work if I make any changes. Here is the link to the previous thread: http://forums.techguy.org/business-...increment-field-including-year-restart-2.html

I have also uploaded the database that was provided in the last post. If I try to change the field and object names I appear to be unsuccessful in having the code still work even when I change the items in the code as well. I woud like some help. I would like for there to be a field called "RequestDate" that has the date stamp that is keyed in by the user. Then after that is keyed in on the form the "AssignmentID" field is updated to the new assignment number. The "RequestDate"="Admit_Date" and "AssignmentID"="ActualFWCNumber". I am trying to do this in Access 2010. If I make changes either the number field doesn't autopopulate or the same number keeps repeating. Any and all assistance on this would be great.

A:Autoincrement field including year - restart each year

tamanthalou, welcome to the forum.
As you have posted the original database a copy of your database with no data in it would be better to understand your problem.

Read other 1 answers

I have an installation folder on my main machine(Windows 7) with all my software. I have repeatedly run into issues connecting odd devices to my shared folder. This time I have installed Windows 10 Technical Preview (on a different machine) and don't understand why it tells me I can't access my own machine. After all these years, you would think user friendly would be a reality. It seems to be a coin toss as to which machines will connect. I hate never knowing I can access my own machine without issue. Here I am trying to install applications but yet I can't get to my storage location.

What is the secret to sharing your machine, so that anyone on the same network can access shared folders?

Edit: I always turn on "Network Discovery" and "File and Print Sharing".

A:Network connection issues (year after year)

I'm more brutal via the firewall:

set trust localhost and your lan ip's, eg

then add two rules for only the PRIVATE PROFILE

inbound allow tcp/udp from to any for ports 137-139,445
outbound allow tcp/udp from any to for ports 137-139,445
I use a much more complicate scheme in reality to enforce known vs unknown devices and to segregate WiFI from wired access, but that's just me.

In services, ensure these are running

Bonjour Service ( mDNSResponder)
Network Connections
Network List Service
Network Location Awareness


Read other 5 answers

I have a sheet with 2 simple columns: Date and Price. I have imported the dates (##/##/####) and the prices ($###,###) by copy/pasting from the search results given to me by a niche database program I use. When the cells paste in, they all have the format "General".

When I try to format the "date" column into dates, it _does_ change the format as far as the cell is concerned, but the content of the cell doesn't adapt to the new format. For example, I have the date as 3/05/2001 and when I change it to a date format of MMM D, YYYY the content should change to March 5, 2001 but it doesn't. It is as if all the cells are forced to stay as text regardless of what the formatting is that I'm applying.

Same problem with the price column: if I change the format to include 2 decimal points, that format does apply to the cells, but the content of each cell remains without a decimal or anything following, as if the content is just text.

I have like 1000 rows in each column, and plan to do this analysis of the database's results frequently, so I'm hoping the answer isn't just to retype the data. There's got to be a way to copy/paste or export or something. Maybe I could copy/paste into notepad first to scrub out any formatting or locking from the niche database program?

A:Excel 2007 Cell Values Won't Take On Characteristics of Newly Applied Cell Format

Good news: Made some progress. In thinking that maybe each value had the textual single-quote forcing it to act like text, or maybe if I find/repaced all the dollar signs and commas that had been imported, I accidentally discovered that each and every value in my imported columns has a following space!

Bad news: Seems like Excel has a bug that thinks that if I say "Find=[singleSpace]" "Replace=[null]", then I should be given an error saying "Excel cannot find any data to replace". I think I'm doing the find/replace correctly because it worked on the dollar signs and commas.

Anybody know a workaround for the bug?

Read other 1 answers

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.

A:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that


Read other 3 answers

I'm attempting to write my first macro for an Excel 2003 workbook. I'm not completely code illiterate (I've got moderate skills with AutoLISP), but I'm new to VBA and am not yet an Excel power user, so please be gentle.

The macro I want to write will:
check that the selected cell's content is underlined before proceeding
copy the content of the currently selected cell into an external plain text .log file
.log file lines should be: year/month/day - time - username - cell contents
.log file names will probably need to be generated
clear the cell's content and formatting (particularly underline and text/background color)
Here's what I have so far:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
If MsgBox("The selected cell is not underlined...are you sure?", vbOkCancel) = vbOk
Then Selection.ClearFormats And Selection.Clearcontents
Else Exit Sub
End If
End If
End Sub
If I've written it correctly, it should currently do everything except log the cell contents. This, from what I've seen, is going to be the trickier part. I intend to use this macro 50+ times per weekday, so at some point the .log files will get too long to be useful, so I assume it will need to automatically create new logs (perhaps "year-month.log"). I've seen some useful info about appending to an external log here and here, ... Read more

A:Excel 2003 macro: log contents of selected cell, clear cell

You need to use the "File Scripting Object" to create and/or append text to a file. I've included a link below to get you started. If you are unable to figure it out on your own let me know and I'll write the code for you.



Read other 1 answers

Hi Tech teams, I went to the lenovo site to customize a T440S Thinkpad and got stuck at the REAR BATTERY selection. I have searched in google and the site and could not see the picture difference's between 6 Cell Li-Ion Cyl HC Rear (72Wh) and 6 Cell Li-ion (47Whr) Cylindrical. I know those will be large and will bulge out of the laptop. But I would like to understand in which way and want to see the pictures of the laptop fitted with these 2, so that I can proceed with my order. Will it come out like a cylindrical bulge at the back of the laptop or at the bottom it will have an extra step like thing. Why dint the lenovo put 3 different pictures showing the laptop with these batteries in the "help me decide" option while customizing the laptop. That would have been very nice to the customers. I have wasted 2 hours to compose this and search everywhere, without any resolution. I found a similar thread in some forum, asking for the pictures, and no one replied him as well. Please see the below screenshot.  ThanksManu

A:Difference between 6 Cell Li-iion Cyl HC Rear (72Wh) and 6 Cell Li-ion (47Whr) Cylindrical

look at Notebookcheck review

Read other 6 answers

I'm running a spreadsheet for yearly budget using EXCEL 2010. Everything has run smoothly until today. If I enter values on one sheet, it shows up on all sheets. I've gone through the settings for EXCEL but cannot find a setting to change this. Anyone have a suggestion on how to correct this?

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Professional , Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz, Intel64 Family 6 Model 30 Stepping 5
Processor Count: 8
RAM: 8183 Mb
Graphics Card: ATI Radeon HD 4600 Series, 512 Mb
Hard Drives: C: Total - 76216 MB, Free - 8485 MB; D: Total - 1907599 MB, Free - 1891982 MB; E: Total - 476809 MB, Free - 409377 MB; G: Total - 2861575 MB, Free - 2680780 MB; J: Total - 238472 MB, Free - 107677 MB;
Motherboard: ASUSTeK Computer INC., P7P55D-E PRO, Rev 1.xx, 103822980000259
Antivirus: ESET NOD32 Antivirus 4.2, Updated and Enabled

Read other answers

Using EXCEL, I have a need to copy the cell contents from upper cells in col. A down a few rows in col A. There are various changes in data in col A as you will see below. The periods in the following info are used as placeholders only. B1, A2, A3, A4, etc. are blank. I need a formula because I have 60,000 records in the spreadsheet. Thanks in advance.

Here is how the data looks now.


Here is how I want the data to look

...A ...........B

A:[Excel] Copy And Paste Upper Cell To Lower Cell

With the workbook open press ALT + F11 to bring up the Visual Basic Editor. Once the VB editor opens, click INSERT --> MODULE and paste the code below into the blank module. Close the VB editor and select the first cell in column A containing your data you want to copy down. Click TOOLS --> MACRO --> MACROS and select the macro from the list and run it. This macro will copy all your data except for the last value in column A because without actually seeing your workbook, I have no way knowing which line to stop at. Therefore, the code will end when it reaches the last value in column A.


Public Sub CopyData()

Do Until ActiveCell.Row = Cells(Rows.Count, "A").End(xlUp).Row

ActiveCell.Offset(1, 0).Select

Do Until ActiveCell.Value <> ""
ActiveCell.Offset(1, 0).Select


End Sub


Read other 2 answers

I want to have a range of cells store something. When one of those cells data is changed, I need another cell to show the date of when the cells data was changed automatically. For example: If Someone changes cell B2, A2 will show the date B2 was changed. Or B78 changes, A78 should show what date B78 changed. I need this to happen for the entire column. Is there a way to have this happen automatically? Please help, if you can.

A:Changing Cell Info, Date tracks when cell changed

Read other 6 answers

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers


I cant seem work out a solution for what I'm trying to do. I have an Excel workbook that has multiple sheets. On sheet 1 i want the data from cell "G3" to be copied onto sheet 2. But i want the location on sheet 2 to be based on whatever was entered into cell "D3" on sheet 1.

For example: Sheet 1, cell D3 I have the name John, in cell G3 i have 68. I want "68" to be pasted in sheet 2 in cell B26.

But if the name in Sheet 1 cell D3 is Suzie, then I want G3 to be pasted in Sheet 2 in cell D26. So I would need to identify the paste location for each person.

I want the data to paste to the next cell so that the next entry can be pasted below the last entry for that person (for John the first entry would go into cell B26, then the next entry would go into cell B27 and so on).

But i want it to be a specific range, i dont want data to be pasted past 20 cells (cell B45). If possible a message box could be created to let the user know that the max is reached.

I would appreciate anyone's help with this as i have been struggling for awhile to try to get this. Thank you

A:Excel - Copy paste cell into range based on another cell

Read other 12 answers

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers

would like to write a macro involving cell references, which changes when the number in another cell changes

e.g if cell = 1, uses b2
if cell = 2, uses b3

please help

A:macro help - linking cell reference to number in another cell

Read other 8 answers


I am attempting to clear 2 cells, based off the value of another. I am pretty sure the code is correct, because it works within another Macro. Thanks.

Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row

For i = 1 To p
If InStr(1, Range("k" & p), "None") > 0 Then Range("L" & p) = "" And Range("M" & p) = ""
'If no Issue, Location/Obsevations should be blank
Next i

End Sub


A:Solved: Clearing Cell Contents Based off other Cell

try this variation;

Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row

For i = 1 To p
If InStr(1, Range("k" & i), "None") > 0 Then
Range("L" & i) = ""
Range("M" & i) = ""
End If
'If no Issue, Location/Obsevations should be blank
Next i

End Sub

Read other 2 answers

Hi All,

I need an help one excel formula ,i have specific range with prices, but when ever there is a change in value in the range then one particular need to be updated with now() formula. Find below the snap shot of desired data....

Product Changes happened Jan'13 Feb'13 Mar'13 Apr'13 May'13 Jun'13 Jul'13 Sep'13
In the above data i have values for all product in all months. if there is any change happened then in the changes happened column need to be updated with now() formula.

Thanks in advance...


A:Automatic date update in a cell when another cell's value changes (as calculated

Read other 9 answers

I selected a cell, and then recorded a macro when I copied the cell, moved down to the cell below it and pasted it. But when I select another cell, and then run the macro, it goes to the initial cells I did when I recorded the macro.

So is there a macro where I have selected a cell, whatever cell I decide, and then run the macro, and it copies the cell selected and paste it to the cell below the cell that was copied?

A:Solved: Macro to Copy and Paste From One Cell to Cell Below

Read other 16 answers

Using Excel 2003 in Windows XP

I would like to use the contents of one cell as the destination location for copying data.
For example
I have 2 worksheets 1) Results and 2) info
in info
A1 = 'ABC'
C1 = 'Results!O54' < this is calculated based on other data in sheet.

Using a macro, I'd like to copy contents of A1 to cell location 'Results!O54' more specifically to where ever C1 points... C1 will change based on other data in info sheet.

The macro record for action looks like this (but I would like the 'O54' to be based on contents of C1 which changes)

There is more to it then that but I think this is where I am stumped.

A:Solved: Excel: Uses contents of Cell to select a cell

Sheets("info").Range("A1").Copy Destination:=Sheets("Results").Range(Sheets("info").Range("C1").Value)

Read other 3 answers

Very limited experience with Excel...have a multi page workbook but can't figure out how to auto format existing text to fit in cells so there is no space either on top or bottom of the cell.

Only way I can get this so far is to manually move the bottom line of the text box up to the bottom of the actual text in box. But this causes the print out to overlap sometimes of the text lines in print view.

Is there a way to 'auto-format' individual cells to fit the text in the cell without leaving alot of space above or below the lines, or top/bottom lines, of the cell.

A:Having problem setting cell height to fit text in cell

When you are in the cell that you want to align with the top, Right Click & select Format Cells & when that opens Click on the Alignment Tab & then you will see Horizontal & Vertical, click on the Vertical drop down arrow & select Top. That will align the text to the top of the cell & eliminate that space.

When you move to the next cell to insert the Dollar amount it will be lined up with the bottom of the text in the previous cell, which is what you want.

Read other 1 answers

I have two cells, Cell "A" and cell "B", that have a formula in each. Cell "A" has a value that is correct and Cell "B" has a value that is correct. I now have a third cell (cell "C") with a formula that takes the values of cell "A" and cell "B" and multiplies them. The value of the product is wrong in cell "C" as compared to a value performed by a calculator. Cell "C" reports 51,550.64 whereas the calculator reports 51,540. What is the problem.


A:Excel cell to cell multiply problem

I'm willing to bet that the number you are entering into the calculator are rounded off while the number that Excel is using is not truly rounded off. Even though Excel may display a certain number in a cell due to its format, it is probably using the true value of the number which probably includes several decimal places. What numbers are showing in cells A and B? How are cells A and B formatted? What happens if you increase the number of decimal points in these cells...do the cell number become larger? If so, then Excel is likely using the true values of the cells instead of the display values in its calculations. Provide details of how you are obtaining your cell values so we can confirm that this is happening.

Try the following

TOOLS --> OPTIONS and choose the Calculation Tab. Put a check in the box marked "Precision as Displayed."
NOTE: This will affect all other calculations on the workbook causing changes to other values on the sheet!


Read other 3 answers

I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always start by saving my most recent version of the workbook with the date I last updated it in the filename, and then when I finish my updates for the day, I save the current day's updated workbook with the current day's date in the filename, etc. So after a while, I've got quite a stack of versions of the same workbook, albeit with slightly different data in some of the cells, from version to version.

Near the end of the year, it'd be neat to be able to compare the beginning and end of year versions, cell by cell, to see what changed.

Ideally, I'd like to sort of "subtract" one workbook from the other, cell by cell, and display something in the results that shows cells that differ btwn workbooks and cells that don't.

Obviously, I could just print the two versions, and plow through them both, side by side. But they're nearly 2,000 rows deep, all things considered, and with all the data we compile for each member, each row goes up to column AT! That's a lotta data to compare visually cell by cell.

Is anything like what I'd like to do possible?


A:Can I compare 2 Excel spreadsheets cell by cell?

I think this might help if I read this correctly. I used this before to compare three lists I made a long time ago, then when I needed to update them I didn't want to sift through hundreds of entries.

Compare Two Lists in Excel - Easy Excel Tutorial

From MS https://support.microsoft.com/kb/213367

Also 4 Ways to Compare Data in Excel - wikiHow

Read other 1 answers

Re:  Battery # 746641-001(3 cell)  I need to replace the battery for my laptop.  Most of the batteries I'm finding are 4 cell and I need a 3 cell.  What is the diffrence between the 3 and 4 ?  Any help would be appreciated.  Terri

Read other answers

Hi Lenovo experts - I am having a strange issue with my new X270 laptop. I have been using it for over 3 weeks now. The X270 came with an integrated Li-Ion 3-cell battery (23 Wh) and also an external Li-Ion 3-cell battery  (23 Wh). With very light usage (just outlook and office apps) and brightness set to 25%, I can barely get 2h-2.5h of battery life. Is this normal? Per the PSREF, 3+3 cell should give me ~13h of battery life.  Anything else I can check? I did a 'battery report' and I see on average 45 Wh of charging capacity when active. However 'Battery life estimates' show between 2h-3h at full charge. 'Current estimate of battery life based on all observed drains since OS install' is showing 3:50.  Do I have a defective battery? Any advice appreciated!

Read other answers