Question about Microsoft Excel for PC
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.
Conditional formatting is alright.
you just have to remove the $ signs in the cell reference when you set a condition.
Posted on Nov 21, 2008
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.
Posted on Jan 02, 2017
Tips for a great answer:
May 15, 2014 | Microsoft Corporation Microsoft EXCEL 97...
Jun 09, 2012 | Computers & Internet
Jun 26, 2010 | Microsoft Office Excel 2003 for PC
Dec 14, 2009 | Microsoft Office Excel 2003 for PC
Mar 21, 2009 | Microsoft Computers & Internet
Dec 15, 2008 | Microsoft Windows XP Home Edition
Dec 18, 2007 | Microsoft Office Standard for PC
Dec 11, 2007 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
677 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: