I am putting together a spreadsheet that will tell me when I need to re-order inventory. So if in column A, the re-order number is 4, then in column B (where I have stock in hand) I need it to turn red when it gets to 4 or below. I have figured out how to do this, I am using Vista. What I can't figure out how to do is to copy the formula down. I was using the conditional formatting, and it is only using cell 1A as opposed to 2A for 2B and 3A for 3B... etc. Hope that I am making sense. I tried to copy and paste special, and chose formatting, that didn't work. I tried to click and drag the formula down, and that didn't work. So I guess that I have to write an if statement that will change the cell red, which I have no CLUE how to do. Please help!! So sorry for rambling, I am frustrated.
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need. goodluck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
On the home toolbar, there is a section titled "Number". That would be where you would change the format to whatever you want it to. Even Red..
So, all you have to do is enter in the number you want and Excel puts in the decimal point, or the dollar sign, or the percent sign for you. And you can even change the amount of decimal places you want it to go as well..
Highlight the cells/numbers you want to format, then go to the number section on the toolbar (edit), and select the format that you want.
Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
there is a popular solution for those who have been locked out by excel spreadsheet. For this solution, what you need is a password recovery tool,Google Excel Password Recovery 5.0 for password recovery. Download and install the software. With Excel Password Recovery 5.0, you can open you excel spreadsheet without data lost.
Here are your links
What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.
Dear pauline, you can link cells in formula bar to see immediate effect of additions and subtractions in dependent boxes.
Like for example you add three numbers in three boxes A1, B1, C1 and answer is supposed to go in D1, just type =SUM(A1+B1+C1) in D1.
now when you will change the values of a b and c boxes, the value of d1 will automatically change. for adding more numbers you can leave boxes empty so that you can fill in later to see the change in the sum box.