Question about Microsoft Excel for PC

1 Answer

If statement that will change cell color in excel

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.

Posted by on

  • heather_will Nov 21, 2008

    Thanks so much! It worked. I was ready to pull my hair out yesterday!

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 45 Answers

Conditional formatting is alright.

you just have to remove the $ signs in the cell reference when you set a condition.

then, copy-paste

Posted on Nov 21, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I fix how my percentage shows on the excel spreadsheet?


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.

May 15, 2014 | Microsoft Corporation Microsoft EXCEL 97...

2 Answers

What is excel


Hi,

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.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

2 Answers

Cant get the Indian rupee format in EXCEL.


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.

Sep 14, 2010 | Microsoft Excel for PC

1 Answer

Hi. By the grace of Almighty it is hoped that you and your family members would be in good health. I need a link to download a multiple sheets Excel Workbook to manage our daily sale, inventory and...


Here are your links Sales
http://www.brothersoft.com/sales-management-report-spreadsheets-for-excel-366701.html
Inventory
http://www.brothersoft.com/downloads/inventory-spreadsheet.html
Purchase
http://www.spreadsheet123.com/ExcelTemplates/purchase-order-template.html

Jun 26, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Change Font color in an excel spreadsheet and it prints correct color but will only show as black on screen.


Make sure you have highlighted yhe area you want to change the color on then click on the color you want and it should change for the screen as well as the printing phase of the program.

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

CSV WYSIWYG


Open the CSV file in an Excel spreadsheet.
Then using the Data Sort feature, you can put your data in alphabetical order.

Aug 07, 2009 | Microsoft Excel for PC

1 Answer

Spreadsheet highlights


you may have to reset your color palet, some program have black/white set as the default

Apr 23, 2009 | Microsoft Office Excel 2007

1 Answer

Excel spreadsheet is protected. I do not remember the password. how can i get in?


lok on google for password cracker for excel download and it will open any locked spreadsheet

Oct 14, 2008 | Microsoft Office Standard for PC

1 Answer

Consolidate few sheets under 1 excel


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.

Dec 18, 2007 | Microsoft Office Standard for PC

1 Answer

EXCEL SPREADSHEET FOR INVENTORY


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.

please press fixya if that has helped you.

Dec 11, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

668 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...