Computer Support Forum

Changing colours of a cell

Question: Changing colours of a cell

Hi I was wondering how can you change the colour of a cell when there are over 5,000 different cells to do? I have 4 colours to refer to and my Excel skills are struggling. I need the cell to refer to a different cell and need to display a number in the original cell. Does this make sense?

Relevance 100%
Preferred Solution: Changing colours of a cell

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.)

Answer: Changing colours of a cell

Sory I have an example - if in A1 I have 1000 and I'm trying to match this numer from K1, L1,S1 or Z1 and each range has a different colour just want a quicker way rather than entering it in for each cell 5,000 times.

3 more replies
Relevance 63.55%
Question: Excel cell colours

Is there anyway of automatically changing cell background colours depending on the value within a cell? As an example, if the value is 0, the cell stays white. If the value is 10 or over, it changes to a yellow. If the value is 20 or over it changes to red..etc etc.?

Answer:Excel cell colours

Yes, it's conditional formatting. Click on Format, then Conditional Formatting.

9 more replies
Relevance 63.55%

Hi to all, KLAMI, a newbie to VBA here, asking for help.
I have a piece of code that currently colors an entire row dependent on the last number digit in a certain column. It then loops and does the same for the entire worksheet if required making rows of the various colors stipulated
Can someone please advise how I can change this to let it to continue to do the same but ignore non adjacent cells that may contain any one of 4 different colors in the same row, i.e. Black, Brown, grey and white?

I would also appreciate if someone could help me speed up the existing loop, if the problem above can not be resolved?

Here is the code that I use:

Sub ColourRow()
'
' Private Sub Worksheet_Change(ByVal Target As Range)
'
' CoulorIt Macro
'
' Dim rng As Range
Dim i As Long
Application.ScreenUpdating = False
Set rng = Range("B1:B5")
i = 2
Do
With rng
If Cells(i, 6).Value = "1" Then
Cells(i, 6).EntireRow.Interior.ColorIndex = 3
ElseIf Cells(i, 6).Value = "2" Then
Cells(i, 6).EntireRow.Interior.ColorIndex = 6
ElseIf Cells(i, 6).Value = "3" Then
Cells(i, 6).EntireRow.Interior.ColorIndex = 10
ElseIf Cells(i, 6).Value = "4" Then
Cells(i, 6).EntireRow.Interior.ColorIndex = 33
ElseIf Cells(i, 6).Value = "5" Then
Cells(i, 6).EntireRow.Interior.ColorIndex = 29
ElseIf Cells(i, 6).Value = "6" Then
Cells(i, 6).EntireRow.Interior.ColorIndex = 45
ElseIf Cells(i,... Read more

Answer:change certain cell colours in VBA

Hi Klami,
I think I can help you if you help me understand what you are trying to do.

Your macro colors rows based on the number in the cell, not the last digit. Do you want the code to find the last digit? The formula is right(target, character).

I am not sure what you mean by non adjacent cells. As the code runs to through do you want it to skip a row if the row above it has a color?

I don't know the use of the 'mg' variable. Are you expecting some condition in the range to impact the code?

Is row 100 significant or did you put it in the code to stop the macro? Would you like it to stop at the last entered value in column F? That may save some time if you only have 20 rows- it would stop rather than keep going until 100.

If you take a few minutes and add more about what you are trying to accomplish, I think we can get you the code to do it.

Stoneboysteve
 

5 more replies
Relevance 62.73%

Hi everyone, is there a way that Excel can be made to change the cell colours depending upon the cell contents? I have a group of cells that display the result of a sum. The cells are green (the default entry is a positive number)the calculations reduce the number and I would like the display cells to change to red when the contents reaches zero or negative.I'm not even sure if it is even possible, but any help would be appreciated.
David

Answer:Conditional cell colours in Excel - help please

Yes. I use this on one my spreadsheets but will have to come back later this evening as I am just on my way out.

3 more replies
Relevance 62.73%

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.
 

Answer:Changing Cell Info, Date tracks when cell changed

6 more replies
Relevance 61.91%

I am looking to change the value in the cell if it meets certain conditions and then the color of the cell if it meets other conditions. ie.... I am tracking the status of some projects. I have dates across the top. If the entered target start date matches the date at the top an "ST" is entered into the cell. If the actual start date matches the date at the top the cell color changes. I cannot use (I think) conditional formating because I don't want to change the cell value. I am thinking something like: =IF($I7=L$6,"CL",IF($H7=L$6,"ST",IF(AND(L$6>=$J7,L$6<=$K7),Change cell color to green,"")))H7 is the Target Start dateI7 is the target End DateJ7 is the actual Start dateK7 is the actual end dateL6 is the date I am comparing to

Answer:Change Cell color without changing the cell data

Conditional Formatting requires only that the formula return TRUE, so If the actual start date matches the date at the top the cell color changes.something like: =IF(J7=L6,TRUE,FALSE) even shorter version: =J7=L6Conditional Formatting 20071) Select your cell or range of cells2) On the ribbon click Conditional Formatting3) Click on New Rules, it?s near the bottom of the dialog box.4) Click Use Formula to determine which cells to format.5) Enter the formula: =IF(J7=L6,TRUE,FALSE)6) Click on the Format button7) Select the Fill Tab8) Select a Green color9) Click OK10) Click OKSee how that works.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 60.68%

Hi,
I'm currently writing a macro, part of which necessitates a different fill colour being assigned to each cell in a range - from B28 to the last cell in column B where there is corresponding data in column C. This could potentially be up to 50 cells in any single worksheet (one month's Arrivals), so 50 different colours, but will more likely be somewhere between 15 and 30.

I found some code that randomly applies the fill colours, and modified it, as follows:

Dim r As Byte, g As Byte, b As Byte
Dim iRow As Integer, iCol As Integer
Dim iRows As Integer, iCols As Integer
Dim rng As Range, rngFill As Range
Dim strMsg As String
Dim iIcon As Integer, strTitle As String
Dim EOP as Integer

EOP = Cells(Rows.Count, "C").End(xlUp).Row

On Error GoTo ErrorHandler

iRows = EOP- 1
iCols = 0
Set rng = Range("B28")

For iCol = 0 To iCols
For iRow = 0 To iRows
r = WorksheetFunction.RandBetween(70, 255)
g = WorksheetFunction.RandBetween(70, 255)
b = WorksheetFunction.RandBetween(70, 255)
Set rngFill = rng.Offset(iRow, iCol)
With rngFill.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = RGB(r, g, b)
End With
Next iRow
Next iColClick to expand...

This works pretty well, but there's always the chance of 2 very similar colours appearing consecutively, which I could do with avoiding...

As mentioned these colours are for Arrivals. I also need to apply colours for Estimated Arrivals in column A. These should be lighter shades of their c... Read more

Answer:Solved: Excel VBA copy cell fill colours and modify

16 more replies
Relevance 58.63%

Is there a way to change the scrollbar colours for all windows in XP Pro?

I have a vision problem that causes blurring at the far right of my field of view. It's normally not a problem, but with the grey on grey colour of the scrollbars, I have a hard time finding it without looking over to the right. I'd like to change the thumb to a dark colour (or the scrollbar background to a contrasting colour) so I can see the thumb position with averted vision (like I used to).

It seems that you can do it with themes, but I can't see how to modify a theme file to do it. Google searches seem to point to lots of theme files, but no theme "coding" instructions. The Accessibility options for visual problems only offer a gaudy high-contrast theme. I only need to change the right scrollbar (if the bottom scrollbar changes as a result, I don't care).
 

Answer:Changing scrollbar colours in XP Pro

I only know the scroll bar will change color if you change your 3D button's color in the appearance section.
 

2 more replies
Relevance 58.63%

My laptop screen when laptop is first turned on or if it is moved just starts flicking from colour screen to colour screen
 
Lenovo G550
Model name: 2958
S/N : CBxxxxxxxx
MO : CB00082286
 
Moderator Note; s/n edited for member's own protection

Answer:Screen Changing Colours

Hi
 
Welcome To Lenovo Community
 
Sorry to hear about the issues you?re facing.  
 
Please contact  local Lenovo service center to have the LCD / LCD cable verified
 
 
Hope This Helps
Cheers!!!
 
 
 
_______________________________________________________________________________________________
Important Note: If you need help, post your question in the forum, and include your system type, model number and OS. Do not post your serial number.
 
Did someone help you today? Press the star on the left to thank them with Kudos!
If you find a post helpful and it answers your question, please mark it as an "Accepted Solution"!  This will help the rest of the Community with similar issues identify the verified solution and benefit from it.
 
Follow @LenovoForums on Twitter!

1 more replies
Relevance 58.63%

This may seem like a stupid question but how do you change the colour of the background that surrounds menu options and toolbars in Windows XP? Mine have always been white but they have suddenly turned grey and I cannot seem to change it back. I have been through all the options in the advanced screen set up in display properties but none of the options appears to adjust the part of the window I want.Any ideas?

Answer:Changing menu bar colours in XP

I'm not exactly sure what you mean by "white",but if nothing in your display properties work why not try a third party app like click here

3 more replies
Relevance 58.63%

Hi I have a problem developing with my monitor in that some times the screen will develope eithera pink or green tint or sometimes a grey tint it comes and goes as it pleases but seem sto be getting worse, do you think the monitor it going pear shape and needs to be replaced or can I do anything to help it along for a bit longer.Many thanks Malc.

Answer:monitor colours changing

monitor VGA cable as it sounds as if there is a lose wire within it. If its a Captive (Perminant fixed cable to rear of monitor, it cannot be replaced)If its not that, its the tube going to fail. Does the colour deteriation even start when you start the machine up while booting up ?. If so I would suspect the cable to be damaged.

5 more replies
Relevance 58.63%

My computer monitor seems to have changed colours all of a sudden and I'm wondering how to fix this problem. It was operating fine 10 minutes ago when everything on the screen changed to a blue tinge.

The contrast/brightness, etc monitor buttons don't seem to be doing anything, neither does fiddling with the video card settings. What else could the problem be?
 

Answer:Monitor colours changing?

Loose VGA cable. Make sure both ends are secure.
 

1 more replies
Relevance 58.63%

I just installed a newer video card, and now my screen is constantly changing from how it should be to a yellowish tint, and then back to regular again. It's driving me up the wall. How do I remedy this?

The monitor is plugged in securely.
 

Answer:Screen changing colours!

6 more replies
Relevance 58.63%

hi people my crt monitor not all the time but quite often the colours change whys that is it my cable, monitor or graphics card

Answer:crt monitor changing colours

Random Colors at random times ?

9 more replies
Relevance 58.63%

I have a windows Vista os.

I have a simple problem. The black text on vista needs to be blue.

I know you can do it on previous versions of vista, but how do i do it on vista?

Its the text colour in the menu bars, websites ect.

Thanks

Gaogier
 

Answer:Solved: Changing colours

Internet Options, General, Under Appearance: Select Colors. Uncheck Use Windows colors. Select colors you want for each catagory

Internet Options, General, Under Apearance: Select Accessibility. Select Ignore colors specified on webpages.
 

3 more replies
Relevance 58.22%

How can the pale grey text displayed on many web pages be changed to black?  It lacks contrast on a less than white background and is hard on the eyes.
 
Help appreciated,
 
Thanks, John.

Answer:Changing webpage text colours in IEx 11

The text colors are controlled by the web pages themselves, where the author has intentionally used pale grey text.

There may be an addon for IE that allows you to locally change the css style sheet to override the font colors. I don't use IE, but I don't think it includes that feature by default.
 
What I do on pages like that is I press CTRL-A to select all of the text, which sometimes changes the color of the text and the background of the lines to make it easier to read - obviously a very stop-gap solution.

4 more replies
Relevance 58.22%

I am considering purchasing a new laptop with Windows XP Home Edition however have no experience with this operating system as have had Windows 98 for years.
I use an essential marine navigation program which requires 256 colour screen which is easy to set with 98.
Is this possible with XP also and how is this done?
 

Answer:changing number of screen colours

Howdy,

You would right click on the Icon for that program and choose Properties and then Compatibility tab and choose to Run this Program in 256 Colors
 

2 more replies
Relevance 58.22%

In the past you could...
Change the font (as well as the size) used in titles, menus, dialogues, file manager windows etc etc.
Change the background colour used in the above, PDF readers etc
Choose your own desktop colour.
Somewhere between Vista and windows 10 all this user choice seems to have vanished. This isn't an academic question, I use these capabilities to improve readability and reduce eye strain. To my vision, Arial fonts are superior as is a parchment background colour and dark desktop colours.
So with microsoft gratuitously taking useful function away again, I'm one of the many hanging on to their old PC.
Thus I am wondering if there are any tools that would give the user the degree of control over appearance that we always used to have... from way back in the days of NT.

More replies
Relevance 58.22%

I have tried a few browsers recently that ahve a bit more colour than IE6 but was wondering if is is posile to customixe the ie6 colours? Looked everywhere but no joy.sanap

Answer:internet explorer - changing colours How/

Go to, Tools; Internet Options; Colours; and choose what you want. You can also change the Font if you wish!Sadly, IE is nowhere near as customisable customisable as some alternative browsers.

1 more replies
Relevance 57.4%

Hi all, was directed here by Microsoft Community. Hope I've come to the right place
At my work we use Windows 7 professional but are working from servers. I think our setup is Workspace Manager.

Anyhow, we have no rights whatsoever to customize anything so that we all have the exact same setup. This is all set by the IT dept.  
Recently I got a new machine and since then my inactive and active title bars have gone weird. Don't really care about the colour however they are so dark you can't read the text.

This isn't apparent in any area of windows. Only in 2 of the programs I use and it isn't the title bars that are the problem, it's the selected and unselected rows. Our IT dept can't figure it out. It's not the programs because they don't have the facility
to customise.

So every morning I have to go to Personalize> Window Color > Advanced appearance Settings and change the Active & Inactive Title Bar colours which fixes it.  (IT have allowed me to access it!) But when I log back in the next
day it goes back to the stupid colours. It's driving me nuts.


It's not even the windows Default colours. Also if I log in to another computer it is not affected.

Does any one know how to fix this? Please!

More replies
Relevance 57.4%

I am having problems setting up the software and installing it to change the colour of my joy cons through my laptop.
Here is the website
https://www.youtube.com/redirect?ev...C5uvLvYpp7tgE7Jt8MTUxNDU2ODEyOUAxNTE0NDgxNzI5
 

More replies
Relevance 57.4%

When you have access to other user's calendar's is their a way to change the individual colours of the calendars? I know you can have them set to all one colour or use the default but does not seem to be an option to change the colours?
 

More replies
Relevance 57.4%

I have an asus gl552vw laptop with windows 10 installed.
A couple of weeks ago, (possibly after a new update?) i noticed that when i'm on the internet and the mouse lands on a link (without clicking) the screen goes a lot lighter, then when i move the mouse off the screen goes slightly blue/darker (especially the search bar)? some of the text looks a bit blurry as well
only does it on chrome and explorer, not a massive problem but very annoying
 

More replies
Relevance 57.4%

Hope to win the price of some help... Recent previous posting hsan't receive anything...

OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Intel® Atom™ CPU N270 @ 1.60GHz, x86 Family 6 Model 28 Stepping 2
Processor Count: 2
RAM: 1015 Mb
Graphics Card: Mobile Intel® 945 Express Chipset Family, 128 Mb
Hard Drives: C: Total - 152616 MB, Free - 112710 MB;
Motherboard: Hewlett-Packard, 1468
Antivirus: avast! Antivirus, Updated: Yes, On-Demand Scanner: Enabled

When one tries to change Firefox fonts' colours unclicking "allow pages to choose their own colours" it triggers a general structure failure, as rupture of Gmail (impossible to use it), Google's black bar appearence, incomplete pages loading, etc. Recently, it costed to me an uninstalling (deleting everything) and a 'clean' installing of a completely new Firefox because either me or kind people who tried to help me, couldn't guess what has happend (because I didn't realize the concomitancy of the change in tools>content>colours with the beginning of failure, that was progressive). Now inmediately I realized the problem and restored back the mentioned setting and trouble disappeared. But, how is it possible that I cannot change colours at my leisure? Specially when Firefox doesn't have by default, any colur change for visited pages. Is it a Firefox bug? Many thanks and kind cheers.

Answer:Firefox 9 severe troubles changing colours

Is it a Firefox add-on? The latest version might not yet be compatible as many add-ons are yet to be updated.

4 more replies
Relevance 57.4%

I am using Windows 98, Excel 2003.

We have 22 charts (pie and horizonltal and vertical bar charts) but the default colurs do not go with the corporate style of the reports that they need to go into.

Is there any way of changing the colour pallette ?
 

Answer:Excel Charts - Changing the default colours

Yes, open the Excel workbook that you want to modify, go to TOOLS then OPTIONS and select the COLOR tab , select a color beside Chart fills then click on Modify. Repeat with each color that you want to modify.
 

2 more replies
Relevance 57.4%

I upgraded my laptop to Windows 8.1 yesterday. Does it remain the case about which I have read so much that the Start screen icon box colours that Microsoft imposed in this version cannot be changed to one's own choice?
I have seven boxes under the group heading, 'OpenOffice'; three are in orange, four are in standard colour, blue in my case. There is no logic to it.

More replies
Relevance 52.48%

I am basically trying to change the color of a if it is before, if its on or if it goes past a certain number of days. Lets say b8 has Jan 1, 2010 and i want it to be green if its before 21 days, orange if its on the 21st day and turn red if it goes past 21 days. I tried to use Conditional Formatting but i dont think i was inputting anything right because nothing was changing colors. Thanks for the help.

Answer:Changing color of a cell if...

You will need three conditional formatting formulasTry these:1: =$B8=TODAY() - select color Orange2: =AND($B8<TODAY(),$B8>=TODAY()-20) - select color Green3: =AND($B8>TODAY(),$B8<=TODAY()+20) - select color Red(I'm using Excel 2000 so the below is from memory so it may be a bit off.)To do Conditional Formatting: 1) Select your cell2) On the ribbon click Conditional Formatting3) Click on New Rules, it?s near the bottom of the dialog box.4) Click Use Formula to determine which cells to format.5) Enter first formula from above 6) Click on the Format button7) Select the Fill Tab8) Select color9) Click OK10) Click OKRepeat for the additional two colorsMIKEhttp://www.skeptic.com/

2 more replies
Relevance 51.66%

why namber with dash in excel considerd as a date for example i want to define bin for histogeram i want to say 10-20 but it will be converted to date in excel how can i manage itanh help appriciated

Answer:changing cell formate to number

Only way I can think of is to define as TEXT.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 51.66%

I would like to change the colour of text in a cell when the text changes based on the value in another cell. I am able to change the text in cell (in my case "A49") depending on the value in cell "H49" using the "IF" function. I have formatted a range of rows including row 49 so that it normally shows in red. However, I would like the colour of the text to change to black in cell "A49"and if possible also the background colour to another specified colour. I have tried to specify the colour in the "IF" function table if the value in cell "H49" is false but may be I am not doing it correctly. Any help will be appreciated.XEL-LEARNER

Answer:Changing colour of text in a cell

Have you tried Conditional Formatting with the following Rule? It works for me.=H49=FALSEIf H49 will ever be empty, Conditional Formatting might pick that up as FALSE (FALSE = 0) so you might want to use this:=AND(H49<>"",H49=FALSE)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 51.66%

How do I pack the following info into an Excel formula?

If A1=1, then cell A6 has a blue background
If A2=1, then cell A6 has a yellow background
If A3=1, then cell A6 has a pink background
If A4=1, then cell A6 has a green background
If A5=1, then cell A6 has a purple background
 

Answer:Excel Cell colour changing

formula is =IF(A1=1,1,IF(A2=1,2,IF(A3=1,3,0))) and then use conditional formatting (from the format menu) - see attached

Hope this helps.
 

5 more replies
Relevance 51.66%

I need to be able to change the colour of a cell in Excell by typing the colour name in the cell.

I have 12 colours that signify teams and I would like to type in a cell the word BLUE and the cell change to that colour without displaying the typed word.

Any idea's
 

Answer:Changing the cell colour in Excell

9 more replies
Relevance 51.25%

This may have been asked but i cannot find it in the forums. I have changed my cellphone provider recently, my phone is an unlocked Lumia 920 from rogers wireless, will i be able to get any future software updates? my understanding is the are pushed by the cell company and not from the os. My home pc runs windows 7 as well so i cannot use the developer tools.

Answer:Updating after Changing Cell phone provider

It should get any updates Rogers sees fit to send.

9 more replies
Relevance 51.25%

I want to change the width of a cell in a row in a table in Word 2003 without changing the entire column width. At times, when I change the column width, it will only do the cell in that column, without the rest above or below randomly. But it won't do it when I want it to. I have tried using the shift, control and alt keys while clicking on the vertical left margin of the cell but to no avail. Does anyone know how to do this directly without a work around of splitting cells or merging them them or making the lines invisible?
Dr. Joe
 

Answer:Solved: Changing cell width in row in table

Read this ---> Resize all or part of a table
 

3 more replies
Relevance 51.25%

I am creating a spreadsheet for work. I am trying to make it so when someone changes a cells data the date that the cells info was changed appears in another cell. I need the date that the cell was changed to stay there until it is changed again. Was changed again the cell should update with the date it was changed. Please help.
 

Answer:Changing Cell info, have date track it.

12 more replies
Relevance 51.25%

ok, look i have a customer that stored somthing in the warehouse in 10/11/2011 and the fee is- for exmaple- 200$ per month ,so i used cell A1 for the name cell B1 for the date he started and cell C1 for the cost,what i need is to make cell D1 to flash red every 10th of any month, and when i write paid on cell E1 it stop flashing untill the next month , i hope that i provided u with enough details

Answer:changing cell color every cpecific date..

Read the Excel Help File (or Google) for Conditional Formatting.You can use the TODAY() function in a Rule and compared it to the 10th of each month to format the cell. However, in order to make the cell flash, I believe that you are going to need VBA. See here:http://www.cpearson.com/excel/Blink...I also don't understand how you plan to use Paid in E1. Once you enter Paid in E1 to stop the flashing, are you planning on deleting it so that you can enter it again next month? That doesn't sound like a good way to accomplish your goal.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 51.25%

Having a list of data, say A1 to A10 In cell A11 I put the max value from A1 to A10 (located in this example at A6 but may vary)Now I want to work with the cell 1 below the max value from the list ( in example A7) <How can I determine at what cell the maximum value (a6) is locatedHow can I put this adress in a formula so I can change that adress to A7 (or B6) by adding somthing to the cell adress?/b>Thanks

Answer:Working changing Excel cell adresses

This formula will return the value in the cell that is one row below the maximum value in the specified range.It should not be used in A11 because it will fail if A10 contains the maximum value.=OFFSET(INDEX($A$1:$A$10,MATCH(MAX($A$1:$A$10),$A$1:$A$10,0)),1,0)MAX will find the maximum valueMATCH will return the position within the range where the maximum value was found. Note: This is not the Excel Row number, but the position within the array.INDEX will return the Address of the cell at that locationOFFSET will return the value in the cell one Row below that Address.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 51.25%

Hi,I need to be able to change the colour of all cells in a workbook, between title=" and ", to the colour red.For example, if I had the following in a cell:<title="Starting a Business">it would change Starting a Business to the colour red.Help much appreciated.

Answer:Excel help changing colour of part of a cell?

re: "all cells in a workbook"All cells in a workbook or all cells in a worksheet?In addition, I assume you mean that you want to change all cells that contain <title="text string"> such that the text string turns red.Can you narrow the range down a liilt bit?e.g. Are these cells all in a specific column or row or randomly spread out through a worksheet?Are they all on one sheet or does the change have to made to multiple sheets?The more detail you provide, the more specific a solution we can offer.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 51.25%

I am trying to change the color of a cell based on the contents of another cell exampleDate visited: acct : :Date next visit12/08/10:acct name other data: 12/05/10When this condition has met I want the whole row to turn red not just one cell. Right now I use Conditional Formatting but it only changes the 12/05/10 cell.

Answer:Excel cell color conditional changing

Assuming your Date is in cell D2 Your Conditional Formatting should look something like:=IF($D$2=TODAY(),TRUE,FALSE)The important point is:Notice the $ symbols are used to anchor the cell reference.Highlight Cell D2 andEditCopySelect the rest of the cells in Row 2EditPast SpecialCheck the Formats selectionClick OKShould get you want you want.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 51.25%

First time coding VBA in excell and I want to execute some code anytime any cell changes in my worksheet. Cant figure out what event needs to call my code.

I attached the worksheet and my test code in the module.
 

Answer:Cant get code to execute upon changing a cell in Excel

10 more replies
Relevance 51.25%

I would like to have my list in excel have every other row of information a separate color so that the list is easy to read. (i.e. blue row, no fill row, blue row, no fill row, blue row, no fill row, etc.) I would like to be able to sort the data in this list without the color of each row sorting with the information. Is it possible to lock the fill properties of cells so that it does not sort along with the information in that cell?
 

Answer:Excel Sorting without cell properties changing

Here's how.

Select however many rows you need (click'n'drag on the row headers).

Choose Conditional Formatting from the Format menu.

Set Condition 1 to Formula Is. In the box, enter

=MOD(ROW(),2)<>0

Click the Format button. On the Patterns tab, choose a suitable blue. Click OK. Back in the previous dialog, OK again. The formatting will not be affected by Sort.

Rgds,
Andy
 

1 more replies
Relevance 51.25%

I have one column with a date which a task was done e.g. 12-12-2007, I have another column which needs to 'track' the progress, in this column i need the task coming up to the three year period 6- months to highlight green, then if the task is entering the 6+ months to highlight orange and if it is on the three year date (12-12-2010) it must be red signalling a reoccuring task must begin

Answer:formula for changing cell colour and working

Let's say your date (12/12/2007) is in E4.Select F41 - From the Ribbon select Home - Styles - Conditional Formatting, 2 - From the drop down select 'Manage Rules' and select 'New Rule'3 - In the dialog box select the last item in the list 'Use a formula to determine which cells to format'4 - Enter the formulas below as a 3 separate Rules, clicking the format button then 'Fill' Tab and selecting a color for each Rule:=IF(TODAY()>$E$4+1095,TRUE,FALSE) Format with Red=IF(TODAY()-$E$4>182,TRUE,FALSE) Format as Green=IF(TODAY()-$E$4<182,TRUE,FALSE) Format as OrangeEach of these formula will use the TODAY() function (which always returns the current system date) to compare the current date to the date in E4.1095 is three years worth of "days" (3 * 365) so if "today" is greater than E4 + 3 years, the cell will turn Red.The other formulas use 182, which is approximately 6 months. Adjust as desired.

31 more replies
Relevance 51.25%

Hi all,

Basically i need to create a spread sheet Cells A2-99 will have dates input into them at different stages i want to make it so if i put for example 01/01/2015 exactly 90 days after that date the cell turns red.

But all dates will be put in at different times and all dates i input will be different is this possible?

Context for this drivers have to fill in a form once every 90 days we need to keep control over this making sure this is highlighted so it can be corrected asap
 

More replies
Relevance 51.25%

I am trying to use part of a macro to change the active cell to a cell address determined from data entered by the user. For example, a user enters a date, the date is compared to a list of dates and when a match is found the cell address is returned. I want to then make the returned address the active cell. Can this be done and if so how?
 

Answer:MS Excel - Changing the Active Cell Macro

You would need to use VB code. I don't think you can record a macro to do that...do you already have a way to find the matching date or do you need help on that part too?
 

3 more replies
Relevance 51.25%

Hello,

I am beginning to suspect this is not possible. What I want is to have a column with "notes" in which the cells (and the rows with them) expand downwards to accommodate additional text. Can this be done? All the online tutorials just seem to think people want lots of nice additional empty white space at the top of the cells when they change the cell height!

Am I missing something? And can anyone help?

Answer:Changing cell height in excel 2013

just select text wrap. Column will get longer not wider though. The effect will be visible after you will finish cell editing or of you preformat cell height then all will be as you write (assuming that cell is correctly pre-formatted)

2 more replies
Relevance 51.25%

I typed text into a cell as part of a reading list and suddenly one of the cells displayed ########## instead of the text which appeared if I double clicked it. What has happened? Why? How do I stop it?

Answer:Excel 2003 cell content changing

Make the column wider or use a smaller font.

3 more replies
Relevance 50.43%

I have the following data:

1/1/05
2/1/05
3/1/05
Each of the cells is formatted as a date, and is a value.
What I would like to do (and what could be done under Lotus) is to record a macro that puts the ' in front of 1/1/05 and makes it a value. I realize there are other ways to do this, but the functionality of adding a character before a value is what I am looking for.

Functionally, I record this macro with these keystrokes:

F2 Home ' Enter

which results in this code:

ActiveCell.FormulaR1C1 = "'1/1/2005"
Range("A3").Select

If I run this macro, it changes the cells underneath to 1/1/05, instead of keeping their date. Where am I going wrong here and how can I make this work?

Thanks!
 

Answer:Solved: Excel and VB: Changing cell value to text with macro

16 more replies
Relevance 50.43%

I have an Excel bar chart for the number of missed calls by Sanitation District. I have a table linked to a cell with a % variable that can be changed and shows what the current missed calls would be if reduced by the %age in the cell. I would like the label color for the chart for the number of current missed calls for each district to turn red if the current number of missed calls is greater than the total in the "variable" table. Confused yet?

If, for example, when the reduction variable of 5% is applied and changes District 1's calls from 400 in Oct last year to an expected 380 for Oct this year but the total for Oct this year is really 385 I want the label for Oct this year (Oct this year is > 380) then I want the 385 label to be red.

I probably haven't explained this very well but one thing's for sure: It would be a lot easier if Excel 2016 would allow conditional formatting to be applied to a chart label.

Fingers crossed folks....
 

More replies
Relevance 50.43%

How do I change a single cell width in a column (i.e. all other cell widths remain unchanged)?thanks for your help

Answer:Excel 2007 - changing single cell widths

Don't think you can. Change the font or size of the font.

3 more replies
Relevance 50.43%

Hello using XP Pro SP3, Office 2003 SP3.
When typing a Aircraft Registration say CS-TJE into a Cell its Automaticall changing when I leave that Cell to move onto another cell. It changes from CS-TJE to CS-THE so the J is becomming a H making it The.
Can someone please help
Cheers
Steven

Answer:office 2003 Excel on XP Pro Cell letter changing !

Tools - AutoCorrect
you will find tje in the list to auto correct to the
just untick "Change text as you type"

2 more replies
Relevance 50.02%

Hi all,

I have done a decent amount of Java, but VB is slightly confusing to me.

I want to be able to write a loop which will copy data, transpose it and then paste it. It needs to do this several hundred times, with each copied data-set being on a new row.
Code:
Dim Num As Integer


For Num = 1 To 10 'start loop

'cut source cells
Sheets("14402-ANSWERS-07-27-05-2").Select
Range("A2:C33").Select
Selection.Cut

'Paste-Copy-PasteSpecial
Sheets("Sheet1").Select
Range("A1").Select
ActiveSheet.Paste
Selection.Copy
Range("A34").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
, Transpose:=True

'Delete Source Rows
Sheets("14402-ANSWERS-07-27-05-2").Select
Rows("2:33").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp

Next Num ' end loop

'Autofit the data
Sheets("Sheet1").Select
Columns("A:AG").EntireColumn.AutoFit

(nb The reason for the cut-paste-copy-pastespecial is because Excel won't cut and paste-special across different sheets.)

As you can see, I'm nearly there, but currently all it does is paste each new set of data over the existing one in cell A34. How do I make it increment the destination row by 4 or 5 on each iteration?

This is incredibly simple, but it won't let me j... Read more

Answer:Solved: Changing a Cell Reference: Noob question in VBA/Excel

You use Activecell.Offset(r,c).select to move from the current cell. You increment r for rows and c for columns.
Excel has no problems with "Paste Special Transpose" when moving from sheet to sheet. I just recorded this Macro of doing just that -
Selection.Copy
Sheets("Sheet2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
 

2 more replies
Relevance 49.61%

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?
 

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

6 more replies
Relevance 49.2%

I have built a simple timesheet for someone in my dept, which includes amongst other things:

- hours worked over a month,
- how many hours owed/extra worked
- a cumulative of this figure over the months.

The requestor wants to be able to type a letter such as 'e' to represent a 07:30hr shift. So they type 'e' and the cell contents change to 07:30. There are about 6 different codes.

Normally a Vlookup would work EXCEPT you can't change the contents of the cell your are working upon.....cicrular referencing!

I could see two ways forward: either a function that allows the above

OR (perhaps more favourably)

leaving the lookups until the hour calculations at the base of the form. i.e Instead of a simple Sum for the hours worked that month, it could read the values in the range, look them up from a table(vlookup), and then sum the looked up figures to give the answer in the 'hours worked' cell.

I vaguely remember this being possible from my university days but can't remember how.

Can anyone help me?
 

Answer:Excel 2003: automatically changing a cell's contents based on keyword entered

9 more replies
Relevance 47.97%

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?
 

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

8 more replies
Relevance 47.97%

It's hard to tell in the photo, but the progress bars are pink and the text is white.  The same thing happens in Windows.  Where background parts of a window are supposed to be white they display as pink, but gray or other colours are mostly OK, and text is OK.  But at some random times the entire screen is OK.
The M4300 had a BIOS update many years ago that was supposed to protect the Nvidia video controller from getting damaged.  For many years it remained OK.
Can anyone diagnose this?
If the video cable came loose I can probably reseat it, but if the Nvidia controller decided it's time to join the club (the infamous Nvidia quality defects from that era) then I don't think I can fix it.

Answer:M4300 some colours pinkish, other colours OK

Dell SupportAssist could do a stress test on the Nvidia GPU.  When the GPU's temperature went over 85 degrees Celsius the entire screen became OK.  But when the GPU reached 87 degrees the fan came on, the GPU dropped back to 83 degrees, and parts of the screen that were supposed to be white became pink again.

1 more replies
Relevance 46.74%

Hi, I'm considering buying a second battery because my current 6-cell (29+ 42T4861) doesn't last more than 6 hours the way I use it. The current battery is in relatively good condition because I used to work while it was plugged in, I don't think the cycle count is greater than 80.  I'm considering the 29++ 9-cell and the 6-cell slice, but I don't know which combination would be the best in terms of battery life.I'm aware that the slice would be more comfortable to use, because the 9-cell sticks out, plus I would have to change batteries every time one discharges. Price wise they are rather similar where I live, considering that I would buy an external battery charger with the 9-cell.  Is there a significant (1-2+ hours) difference between the two batteries, or is it negligable? Thanks in advance, and my apologies if this was asked in the past.

Answer:X220: 6-cell + 9-cell vs 6-cell + slice (6-cell)

damnated,according to PSREF (tabook.pdf) the following batteries are compatible with x220 at present time:ThinkPad Battery 44 (4-cell) 0A36305 ann 06/05/12ThinkPad Battery 44+ (6-cell) 0A36306 ann 06/05/12ThinkPad Battery 44++ (9-cell) 0A36307 ann 06/05/12ThinkPad Battery 19+ (6-cell, Slim External) 0A36280 ann 03/01/11You see 44-series batteries instead of 29-series which are discontinued.As for the battery life look at this data from tabook.pdf also:4-cell (28Whr): up to 4.1 hr;6-cell (62.4Whr): up to 9.2 hr;9-cell (99.9Whr): up to 13.8 hr;external battery (64Whr): up to 9.4 hr;9-cell plus external battery: up to 23.2 hrAs you see 9-cell and external batteries combination is the best. There is no problem to use these batteries together.

2 more replies
Relevance 45.51%

Hi,Really stuck here and looking for some help.I have an excel sheet that I want to use to record the times people work a shift at work. The sheet is set up as follows. D3 has the workers name that I manually type in.E3 has a drop down list of times of the day at half hour intervals (08:00, 08:30, 09:00 and so on up to 17:00). This is to represent the start time.F3 is the exact same as E3. This is being used to represent the end time.Underneath those cells on row 5 I have the timeline across the page. A5 has 08:00. B5 has 08:30. C5 has 09:00 and so on again up to 17:00.On row 6 directly underneath the times I have the conditional formatting currently set up so that when a start and end time are selected up the top the cell in row 6 under the chosen times turn green.Here's the tricky part. How do I get the cells (in row 6) between the chosen times to also turn green so that basically if I select 08:00 start and 16:00 finish I have a line of green cells representing the shift?Hope that makes sense? Help anyone?

Answer:Excel help - changing cell fill based on another cells fill?

I reread the original post, and I think my first answer was incorrect, as it applies to Row 5. In the original post Row 6 was specified as the target row.If it is Row 6, which is a Blank Row with no data on it, then this should work:1) Select your cell or range of cells, IE A5:S5 A6:S62) On the ribbon click Conditional Formatting3) Click on New Rules, it?s near the bottom of the dialog box.4) Click Use Formula to determine which cells to format.5) Enter the formula: =AND(A$5>=$E$3,A$5<=$F$3)6) Click on the Format button7) Select the Fill Tab8) Select a pretty color9) Click OK10) Click OKEDIT: Put the wrong row number.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

11 more replies
Relevance 44.28%

My computers wallpaper recently appeared grey as if it was running in safe mode but when I cheked it was running on normal so I checked monitor and found it had changed to 16 bit colour instead of 256, however, every time I change it it changes straight back, I do reastart every time I change the colours, HELP, thanks Il campanissimo

Answer:change colours from 16 bit to 256 colours

Which version of Windows?

2 more replies
Relevance 42.23%

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?
 

Answer: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?
 

1 more replies
Relevance 42.23%

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.
 

Answer: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

Pedro
 

3 more replies
Relevance 42.23%

I am working on a excel spread sheet for my job. It has the following conditional formatting. If text is nmcs text will be red and I need a code to make another cell match the color of the nmcs cell but keep the information from another cell that is linked. Please help!

Answer:Excel code needed 4 matching text color only 4rm cell 2 cell

Why not just use the same conditional formatting rule for the linked cell? e.g. If you want B1 to match A1, just CF B1 with something like:=A1=''your text string''Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 42.23%

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:
Code:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
Else
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

Answer: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.

http://www.virtualsplat.com/tips/visual-basic-fso.asp

Rollin
 

1 more replies
Relevance 42.23%

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

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

Hi,
 
look at Notebookcheck review

5 more replies
Relevance 41.82%

Hello, Can anyone help? I need to run a script that will determine if a1 is blank, paste the information from a2 into the a1. If a1 is not null, it should do nothing. This needs to be run for every other cell. If a3 is null, paste information from a4. If a3 is not null, do nothing. And so on, and so on. Any ideas?? Thanks in advance! <config>Mac OS X / Firefox 10.0.2</config>

Answer:Excel script/formula to copy cell if above cell is null

This code should do what you ask for A1:A21.You should try this code in a back up copy of your workbook since Macros cannot be easily undone.Sub CopyIfNotBlank()
For rw = 1 To 21 Step 2
If Cells(rw, 1) = "" Then _
Cells(rw, 1) = Cells(rw + 1, 1)
Next
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 41.82%

Hi, i have this excel data tableDate Application No. Calls Type 1/25/2012 Login 36 Login Call Back 21 PC Software Business Apps 32 PC Software Apps 49 Printer Outlook 13 FirecallThese all are cell A1,B1,C1,D1, though it looks messed up there but all application,calls and types are below eachother and date in first cell , i have to break it into multiple cell such as for each 5 same date 1/25/2012 on one row will have corresponding data.eg.1/25/2012 Login 36 login1/25/2012 Business App 32 PCSoftwareI know i have to use VBA but don't have idea please help me.

Answer:Break 5 items in single excel cell to multiple cell

i am slightly confused with you question, it kind of doesnt make sense to me, maybe im being stupid.can you clarify:where does the below data sit? in one cell or multiple cells?Date Application No. Calls Type1/25/2012 Login 36 LoginCall Back 21 PC SoftwareBusiness Apps 32 PC SoftwareApps 49 PrinterOutlook 13 FirecallDo you just want to split this data into seperate cells? if so then i'd assume the entire data is in one cell, right?please explain and i can try help you with the vba.

10 more replies
Relevance 41.82%

I just wonder if a Lenovo Notebook Z710(59396561), 17.3" Intel Core i7 4700MQ, comes with battery other than 4 cell, say a 6 cell battery? Is there any 6 cell battery for this type of machine?

Answer:Lenovo IdeaPad Z710 battery type, 4 cell or 6 cell?

hi liangxiang,
 
Welcome to the Forums.
 
From the IdeaPad Z10 SKUs that I've seen (US Models), all of them comes with a 4-cell battery which lasts an average of 5hrs.
 
This Lenovo Z710 (59396561) model though is advertised as having a 6-cell battery.
http://www.amazon.com/Lenovo-Notebook-Z710-4700MQ-2-40GHz/dp/B00IRIJVAC/ref=sr_1_1?ie=UTF8&qid=13953...
 
 
Regards 

1 more replies
Relevance 41.82%

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.

....A.....B
Apple.........
..........Fire
..........Ice
..........Snow
Peach
..........Sleet
..........Rain
..........Fog

Here is how I want the data to look

...A ...........B
Apple
Apple.......Fire
Apple.......Ice
Apple.......Snow
Peach
Peach.......Sleet
Peach.......Rain
Peach.......Fog
 

Answer:[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.

Code:

Public Sub CopyData()

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

ActiveCell.Copy
ActiveCell.Offset(1, 0).Select

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

Loop

End Sub


Rollin
 

2 more replies
Relevance 41.82%

Hello,

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
 

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

12 more replies
Relevance 41.82%

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.

More replies
Relevance 41.82%

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.

More replies
Relevance 41.82%

I have two external battery packs, the 3 and the 6 cell batteries. Neither of them will charge at full capacity. The laptop is brand new, as well as the two batteries.  The 6 cell battery is shown as charging, but it is stopped at 59%, and Power Manager shows 5:00 hours to fully charge (it shows this constantly, with no change whatsoever).  Similar problem with the 3-cell battery, stopped at ~75%.  I have deleted the battery driver from Win7 Control Panel. I have changed Charge Mode from alway fully charged to battery health and back to full charge, I have also tried 80% charge threshold.  Running Windows 7 (downgrade form Win8) Any advice?  

Answer:uT440s Battery not charging to full capacity- 3-cell & 6-cell

Hi Radu_umbres,
 
Welcome to Lenovo Community!
 
As per the query we understood that you are issue with the Battery not charging completely on your ThinkPad T440s.
 
To resolve this issue please restart the system connecting ?Power Adapter?. Wait till the system boot completely and then go to ?Device Manager? then uninstall ?Microsoft ACPI-Compliant Control Method Battery? under battery option. After uninstalling shutdown the system, remove ?Power Adapter? and reconnect, then switch ON the system and check if the issue still persists.
 
Hope this helps.
 
Best regards,
Hemanth Kumar





Did someone help you today? Press the star on the left to thank them with a Kudo!If you find a post helpful and it answers your question, please mark it as an "Accepted Solution"! This will help the rest of the Community with similar issues identify the verified solution and benefit from it.Follow @LenovoForums on Twitter!

7 more replies
Relevance 41.82%

Hi
A simple question, I hope the answer is as simple !
If I enter a name in a cell i.e. Bill Bloggs, how can I make the adjacent cell put another name i.e. John Smith? There are about 75 names to put in the first cell.
Thanx in advance

Answer:Excel question - Imput in cell - next cell auto fills

I think you'll need to clarify your question.
Do you mean there are about 75 names to put in the first column (or row)?
Where is the information for the auto-fill coming from?
Please explain what you are trying to achieve.

9 more replies
Relevance 41.82%

The way I have set the work sheet I am trying to keep (D4) always refer to (O4:AG) (works fine with $) but after cells are inserted to (M4) the reference moves with it.From all I've read I'm still not sure which formula to use.I've tried to in both Excel 2010 & Open Office Calc 4.1

Answer:Keep cell locked to specific cell range when inserting cells

I'm confused by your question in a couple of manners.First, you say that D4 refers to O4:AG. Do you mean O4:AG4? There should be a Row number after AG.Second, I don't see why you want to lock the reference to O4:AGx if you are inserting cells. If you insert cells between Column D and Column O, Column O will move, as will all the data that is in it and any column afterwards.If the formula in D4 doesn't change when the columns move, then the formula will no longer refer to the same data.Please explain what you are trying to do in a little more detail.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

15 more replies
Relevance 41.82%

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 1.0.0.1
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
 

More replies
Relevance 41.41%

Hello,I have worksheet that has merged column:C46:C49, (which contain Number Format Cell), D46:E49, F46:K49, L46:M49 (which contain Currency Format Cell),N46:R49, S46:U49 (which contain Currency Format Cell),V46:Y47, V48:Y48 (which contain Date Stamp Format)V49:Y49 (which contain Time Stamp Format)Z46:Z49, AA46:AA49I wish to have a Active X Command Button that can copy all above cell and insert the copied cell in next down row with keeping the same format and merged cell and looping function.Appreciate the help. Thank You.

More replies
Relevance 41.41%

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
Apple
Orange
Pineapple
Fruits
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...

Vinwin
 

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

9 more replies
Relevance 41.41%

Hi,Can someone please help me? I am trying to figure out the best way to do this. I have a dropdown (picklist) in one cell and based on what is picked I'd like for Excel to autofil another cell A B 1 Picklist Prefill 2 Red Sneakers For exampe when I pick Red from the picklist in A2, B2 will autofill as Sneakers. Thank you!!!!!!message edited by HarrisLyfe2016

More replies
Relevance 41.41%

Hello,

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.
Code:
Sub REMOVE()


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


For i = 1 To p
Range("k2").Select
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


 

Answer:Solved: Clearing Cell Contents Based off other Cell

hi
try this variation;
Sub REMOVE()

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
 

2 more replies
Relevance 41.41%

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
 

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

8 more replies
Relevance 41.41%

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?
 

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

16 more replies
Relevance 41.41%

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.

Answer: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.

1 more replies
Relevance 41.41%

I have a scoreboard program that updates a gymnasts position within a range to show their current position, after entering each score i.e.1st, 2nd or 3rd
Is there a way of highlighting the cell or the text colour so that it can be located more easily?
The formula used for updating the position is =IF(G3=0,"",RANK(G3,G$3:G$11))
assuming gymnasts in the rang g3 to g11 i.e. 9 gymnasts
all help most welcome
Thanks

Answer:excel problem highlighting cell or text in cell

Try conditional formatting. If this does not help, please provide more details of the spreadsheet content please.

3 more replies
Relevance 41.41%

I need to show the sum total of 2 cells. The top cell will always have a value. The bottom cell will not always have a value.I want the target (sum) cell value to show only when the bottom cell has a value zero or upwards. If the bottom cell is blank I don't want a sum total to show. In other words I don't want the blank cell to be recognised as zero value until a zero or other number is actually entered in to the cell. I hope you can figure out what the heck I'm talking about. If so, can you help?ThanksJim

Answer:Excel cell formula to disregard empty cell

=IF(A2="", "", SUM(A1:A2))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 41.41%

Reading data through RSlinx to a 12 cell row, A10:L10 in Excel 2003. The cells contain reference links to the external data. I need to copy the received data only not the links, down 2 rows to a clean row. Example: The RSlinx references are in A10:L10. Want to move the received data only to A12:L12.

Answer:vba, move data only from a formula cell to a clean cell

Have you tried:Copy...PasteSpecial...ValuesThat is the standard way to copy/paste data from a cell that produced the data via a formula.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 41.41%

Hi I want to separate cell b which has the fist and last name tocell a only first namecell b only last nameat the moment it is in cell b both first and last name in cell B eg. anna taylor

Answer:Copy paste half of cell in Excel cell into two

Since your data is already in Column B, you must extract the last name into another cell.Have you tried the Data...Text To Columns feature? Use the "space" as the delimiter.If you want to use a formula, you can try these:For simple 2 string names such as "Anna Taylor", try this:First Name:=LEFT(B1,FIND(" ",B1)-1)Last Name:=MID(B1,FIND(" ",B1)+1,LEN(B1))If you have names with 3 strings such as Anna Nicole Taylor, you can do it 2 steps by extracting the names twice, e.g.First Name formula: AnnaLast Name Formula: Nicole SmiththenFirst Name formula :NicoleLast Name formula: SmithThere are also some longer formulas that will extract the middle and last names directly. You can Google around and find various versions.You might also want to try this site:http://www.cpearson.com/excel/first...Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 41.41%

I have a master sheet that we are using to update pricing. What I would like to do is go through all the worksheets in the workbook and find the matching descriptions and update a "Purchasing Notes" cell value with the current price and date that I have combined in another cell. Is this possible?

Answer:Update Cell Value on Multiple Sheets that Match Another Cell

What do you mean by "find the matching descriptions"? Are they in all different locations on different sheets? Can you not simply use this formula?=SHEET2!A1I think we are going to need some more detail related to your workbook before we can offer a solution.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

4 more replies
Relevance 41.41%

I received my U150 (690969U) 06/07/2010, but it came with the 3 cell battery and not the 6 cell as shown when I placed my order.  Who do I contact to get my 6 cell battery? Thanks in advance!.

More replies
Relevance 41.41%

According to the specification of the x200 series battery ThinkPad X200 Series 4 Cell Li-Ion Battery (43R9253):Approximate height: 12.9 mm (0.51 in)Approximate width: 207.4 mm (8.17 in)Approximate depth: 53.5 mm (2.10 in)Weight: 206.0 g (0.45 lb)ThinkPad X200 Series 6 Cell Li-Ion Battery (43R9254):Approximate height: 20.0 mm (0.79 in)Approximate width: 208.0 mm (8.20 in)Approximate depth: 53.4 mm (2.10 in)Weight: 330.0 g (0.73 LB)ThinkPad X200 Series 9 Cell Li-Ion Battery (43R9255):Approximate height: 20.0 mm (0.79 in)Approximate width: 231.3 mm (9.11 in)Approximate depth: 78.5mm (3.09 in)Weight: 510 g (1.12 LB)Looks like the 6-cell battery will extend in the bottom for 7.1mm while which 9-cell battery will extend in rear for 23.9mm and in the bottom for 7.1mm. My question:If equiped with a 6-cell battery or 9-cell battery, can I place the x200s on the dock station without removing the battery? Thanks

Answer:X200s with 6-cell or 9-cell battery + docking station

bump!

2 more replies
Relevance 41.41%

Hi,I've read through some other very similar posts and tried to make other solutions work to fit my problem however I've had no joy and it has been years since I really delved into formulae on excel.I work in a pool hall and am trying to create a spreadsheet to account for table usage. -What I am looking for is the current time (24h format) to be entered into column C when the user enters what table the customer has selected in column B (integer).-If possible I would also like to enter the finish time into another column (D) when a checkbox is ticked. This would allow the staff to work out rates without having to input times in a 24h format which I assume would confuse them plenty.The second aspect to the problem is not as important as I am sure I could patch something together to enter the time if I can figure out the first part of the problem.I am using excel 2002 (part of the office xp package)Any help would be awesome,regards,Joe

Answer:Adding date into cell when data is added to another cell

Have you considered using a commercially available "pool hall management" software package? I did a quick Google search and found a few products, one for under $400. These packages have features like waiting lists, table usage data, food order tracking, and even the ability to control the lights over the tables.As far as Excel goes, you will need a macro to add the time based on the input of a table number. Excel has a feature known as Event Macros which run when a specific event occurs. For the Start Time, you can use the Worksheet_Change event which will run whenever a change is made to the sheet. The first thing it will do is check to see in which Column the change was made and if it matches the specified conditions (1 cell changed in Column B) then it will proceed with the rest of the instructions - e.g. put the time in Column C.For the Finish Time, you can use the Worksheet_BeforeDoubleClick event so that the user simply has to double click a cell in Column D to insert the time.Right click the sheet tab for the sheet you want this to happen in and choose View Code.Paste the following code into the pane that opens. When a value is entered in a cell in Column B, the corresponding cell in Column C will display the current time.Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Cells.Count = 1 Then
Range("C" & Target.Row) = Time
End If
End Sub
For the Finish Time, paste this code in the same pane. When the user double clicks a cell in Col... Read more

2 more replies
Relevance 41.41%

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)
Range("A1").Select
Selection.Copy
Sheets("Results").Select
Range("O54").Select
ActiveSheet.Paste
Sheets("info").Select

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

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

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

3 more replies
Relevance 41.41%

This may sound like a very strange issue, but I guarantee it is real. I ordered a T440s on the Lenovo outlet last week and I received it a few days ago. It came with a 6 cell battery, but Lenovo was supposed to ship me a 3 cell. Tech support shipped me out a new 3 cell battery. I tried to put it on my laptop, but I just got an error that said "Battery 2 has an error." So they sent me a new 3 cell battery with the same FRU, since myself and tech support thought the 3 cell battery was dead. The new one STILL does not work!! I get the same error! I have tried charging overnight, reinstalling Windows, updating BIOS, reinstalling drivers, installing old drivers, and even running Ubuntu and Linux Mint and none of these fixed the issue, so it is either a hardware issue or both batteries are faulty... I mean the 6 cell battery works flawlessly! It is just the two 3 cell batteries that do not work in any OS under any conditions. The internal battery is fine. I'm probably going to return the laptop to Lenovo outlet (they shouldn't charge me a restocking fee for a hardware defect) but I thought I would try one last time to see if you guys know what is going on. Anyone have any ideas?

Answer:T440s rejects ALL 3 cell batteries, only accepts 6 cell

I got the same situationAny help?

1 more replies
Relevance 41.41%

There're a couple of things I'd like to do with a macro or some kind of key-in:1. To move the content in an active cell to 6 cells (columns) to the right, remaining on the same row.2. To move the content in an active cell to any other cell when selected (clicked).Any help will be appreciated. TIA.

Answer:Moving cell data to another cell (not copy and paste)

Your first question is relatively simple compared to your second. This code will Cut the currently ActiveCell and Paste it 6 columns to the right in the same row.
Sub CopySixColunmsToRight()
ActiveCell.Cut _
Destination:=Cells(ActiveCell.Row, ActiveCell.Column + 6)
End SubYour second question is a bit more complicated.You say you want the "ActiveCell" moved to a cell which the user will click. Well, guess what happens when that cell is Clicked? It instantly becomes the ActiveCell and all knowledge of the previously ActiveCell is lost.While there is a way to capture the Click event and run VBA code when the Click happens, the code is not going to know which cell was Active before the next cell was clicked. In other words, let's say the ActiveCell is A1. When you click in B1 and the code fires, the VBA is going to pick up B1 as the ActiveCell and not know anything about A1.Perhaps you need to rethink your second requirement. I don't think you can do it automatically. I think you are going to need some kind of InputBox asking the user to click to Source cell so the code can capture the address.For example, with code below the user can DoubleClick the Destination cell to get the InputBox to appear, asking him to select the cell that he wants moved. That will capture the address of the "source cell" so that it can be moved when the user clicks OK.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error GoTo Cancelled
Set srcCell ... Read more

5 more replies