Numbers turn red when equals to 0

Good day,

Im monitoring our stock inventory using excel, i just want to know if I
can make a certain cell turn red if my inventory is >5 or equal to
zero.?

Thanks


-- 
shiela21cute
------------------------------------------------------------------------
shiela21cute's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33169
View this thread: http://www.excelforum.com/showthread.php?threadid=529926

0
4/5/2006 7:43:48 AM
excel 39879 articles. 2 followers. Follow

2 Replies
445 Views

Similar Articles

[PageSpeed] 0

Check out Conditional formatting

Ed


-- 
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30736
View this thread: http://www.excelforum.com/showthread.php?threadid=529926

0
4/5/2006 8:56:09 AM
got it thanks


-- 
shiela21cute
------------------------------------------------------------------------
shiela21cute's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33169
View this thread: http://www.excelforum.com/showthread.php?threadid=529926

0
4/5/2006 9:34:25 AM
Reply:

Similar Artilces:

CRM 3.0 - Web UI
Just wondering if anyone else has had this problem occur with their install of CRM 3.0. When you try to access the WorkPlace >> Calender page within the web application, i always get an error message when it tries to open the aspx page (home_calender.aspx). The error states "Unexpected error - an error has occured contact your system administrator" Any ideas as to why i would not be able to open this page ?? The user trying to open it has all roles assigned to it within CRM, and is a domain admins (Windows 2003 server, running Sql 2005, Exchange 2003) I am experienci...

Negative Numbers in Brackets
Hi, I have read every questions and replies on this site in order to get my negative numbers to show in brackets and nothing works. I am desparate. The regional settings are changed to indicate negative numbers in brackets but when I try formatting the cells in Excel, I cannot get the numbers to show in brackets. I have Windows XP, Office 2003. Please help me... Thanks. Are they seen as numbers at all? Widen the cell, don't force any aligment, are the numbers left or right aligned, if they are left they are seen as text you can also try =ISTEXT(cell) if it returns TRUE they a...

Converting Numbers to Time (A second probelm)
Due to several peoples help in this group I learned some very helpful date/time functions but here is one that has since eluded me... What I am trying to do it convert... 1/6/1900 22:40:25 to the total number of hours and seconds. As if the start date was 1/1/1900 00:00:00. Or in other words I have a start date of 4/6/2005 11:54:53 End date of 4/7/2005 14:07:00 Total time of 1/1/1900 2:12:07 How do i convert the 1/1/1900 2:12:07 into 26:12:07 Thanks for all your help, Steve smonczka@hotmail.com Just format the answer cell as [hh]:mm:ss -- HTH Bob Phillips "Smonczka" <...

Ingenico with RMS 2.0
Everyone, I am having a very hard time finding information on installation & configuration of the i6550. Has anyone out there been able to make this work and be willing to share their documentation and/or procedures? I follwed the KB article 935588 but all I get is a blank screen once the device boots. I would immensely appreciate any detailed documentation/information that I can get my hands on. Thanks very much! -- Elizabeth Hi we had some help installling this and I can remember most of it. Did you install the Ingenico setup program? Please send me a private email and ...

Function to find largest number from a series of numbers?
Is there a function to go across several columns of numbers and pick out the largest one? If not, how would I write that function? thanks to all Rick =MAX(A1:Z1) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "rs" <r_schiller@REMOVEcomcast.net> wrote in message news:2p-dnW3P0f...

In CRM 3.0 is there a way to Hide the Sales or Maketing or Service
I want to be able to control users access to different sections of CRM. So I want Jane Smith to see Sales and Marketing, and Scott Riley to only see Sales and Service. Doing by team would also work. I was able to create custom Roles and control entiy access but I don't see a way of controlling section access. Mike Sections only appear if the user has access to one of the items within that section. Unfortunately, there are some shared objects across the sections (like Account/Contact) that prevent them from disappearing totally. -- Matt Parks MVP - Microsoft CRM "Hotwheels...

SQL server process scheduling from GP 9.0
hi friends, I have created a stored procedure in ms sqlserver. i need to run this process after certain interval which i want to handle from G.P. i.e. i want to schedule this back end process to run after every 1 min. this i want to manage from G.P. 9.0 can anyone help me out thanks in anticipation ...

3party Omni prices for version 9.0 dynamics
I want to if the omni prices works in dynamics 9.0 I have it working on a couple of V9.0 Sites with no problems noted. -- Richard L. Whaley Author / Consultant / MVP http://www.AccoladePublications.com Documentation for Software Users "Pedro Ramos" wrote: > I want to if the omni prices works in dynamics 9.0 > > > Have a look at the downloads pages of Winthrop's web site (http://www.winthropdc.com), you can see which versions are supported. David Musgrave [MSFT] Senior Development Consultant Escalation Engineer MBS Support - Asia Pacific Microsoft Busi...

Include Row number to print
Hi Expert, How could I include the row number in my printing? Thanks for your help. One thing more, Can I copy the row number only to another sheet? "Rechie" wrote: > Hi Expert, > > How could I include the row number in my printing? > > Thanks for your help. The ROW() function will return the row number. =ROW() will always return the current row number =ROW(A5) will return the row number of the referenced cell (5 in this case) on another sheet you could use something like: =ROW('First Sheet Name'!A5) which would return 5 also. &qu...

How to turn off warning when hyperlinking to other program?
I am hyperlinking cells in Excell to sound files on my hard drive which open up Windows media player and play the files. However, when I click the hyperlinks, office opens up a warning window stating "Some files contain viruses . . . it is important that this file is from a trustworthy source." How do I stop this warning from appearing? ...

How do I import/open .dbf with large number of fields?
I need to import/open a .dbf file that contains about 350 fields. When I open it in excel, it only seems to open the first 245 fields (to column "IU") and doesn't show any fields beyond that. Is there a way to get all the data for a .dbf with a large number of fields? Is there an option for this in Excel or a way to do it in VBA? ...

CRM 3.0 #2
Many times i try built new campaign and i have a problem with template, i want use some "template" to mailing action, because i don't want do 100 e-mails by foot. please help me sroobka@o2.pl ...

Outlook turns into an explorer
Hello All, I have a very worrying problem with a friend's outlook express. Every time she launches it, the toolbar is filled with unwanted panels and the main section turns into an explorer page and downloads some kind of website with a blue background. This is very annoying! Obviously this is infected with spyware or something. I have tried running spybot without success and was wondering if anyone had any ideas on how this may be fixed. Many thanks in advance, Richard Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum. Outlook Express is family of Inter...

Integration between MS CRM 3.0 and OA2007
Hi guys, Have you heard of any tool that provides integration between MS CRM 3.0 and OA2007? Recently, it seems that a number of people are looking forward to have this tool. In line with this, we are currently developing a connector between Microsoft Dynamics CRM 3.0 and Microsoft Office Accounting 2007, and we are looking for CRM users, small business specialists and interested professionals who are willing to be advisors for this endeavor. Advisors will have the chance to influence the features of the software we are building and will get to evaluate pre-release versions of our applicatio...

count matching numbers
This is probably simple but I'm about to go crazy trying to figure it out. Please help. I'm trying to count or total how many cells match another row of cells. For instance A4 = 23 B4 = 14 A5 = 34 B5 = 30 A6 = 39 B6 = 34 A7 = 48 B7 = 39 A8 = 53 B8 = 55 The answer I'm looking for is 2 because there are two cells that match. (A5 matches B6 and A6 matches B7) Thanks, mike Try ths: =SUMPRODUCT(--(ISNUMBER(MATCH(A4:A8,B4:B8,0)))) -- Biff Microsoft Excel MVP "Catfish" <mtblanton@gmail.com> wrote in message news:491279e0-18f9-4d29-a...

Access Denied when connecting to CRM 1.0
Hi, When accessing the MS CRM 1.0 Server I am always receiving the 401.3 error, access denied/unauthorised to access this resource etc... I am a domain user on a computer connected to the domain (SBS2003 with CRM running on a Win2K Server). IIS 5 is configured for Windows Authentication only and the web page is prompting for a username and password but failing for my domain user account however it succeeds for the domain administrator account. I have an MSDN edition of CRM and have licensed it successfully using the MSDN Subscriber Organisation etc. I am registered in the CRM as a user with ...

Store Operation 2.0 In Item Property showing On Order 6 or so.Need
I my Store Operation 2.0 database in am showing some #s in on order. I alreddy all PO closed and I don't have any any back order and its still showing On Order Quantity (Different #s for different items) How do I make this On Order Quantity Zero "0" I am looking for SQL query Update Items Set OnOrder = 0 some thing like that but I dont know the Database field name for Onorder Please help me. ...

Can i print copy numbers?
At my job we must print copies of databases and keep track of them. We only print 100 copies at a time. Is there a way to make it automaticly put "1 of 100" or "copy 1 of 100" in the footer?? You could run a little macro: Option Explicit Sub testme() Dim iCtr As Long For iCtr = 1 To 3 '100 when you're ready With ActiveSheet .PageSetup.RightFooter = "Copy " & iCtr & " of 100" .PrintOut preview:=True 'false when you're ready End With Next iCtr End Sub I used 1 to 3 and pri...

How can I turn off all formulas in Excel?
I am using Excel to make forms and I do not want any formulas. Even when I choose text in the format of a cell, Excel still puts in the formula. Example: When I type "+1% chance for 4 bolts to corrode" in a cell already formated as text, excel still changes it to a formula. There has got to be a setting I could use to turn off formulas when just using Excel as a form builder. Just format the range (or entire sheet) as Text beforehand (eg: select range, click Format > Cells > Number tab. Select "Text" > OK) -- Max Singapore http://savefile.com/projects/236895...

Day to day number of not answered requests
Hi, I'm having a following table : A request id B request detail C request date D answer date Is there a way, with a pivot table, to get the following table : A date B number of not answered requests ?? -- Message posted from http://www.ExcelForum.com How about: =COUNTIF(D2:D65536,"")-COUNTIF(C2:C65536,"") This will give an incorrect answer if there are any answer dates without request dates. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "n61 >" <<n61.18cj37@excelforum-nospam.com>...

Formatting numbers
Pub2002/XP - how to format numbers in a table - I want it to automatically space for thousands etc and align the numbers correctly ie. 1 650 243 500 etc You will have to do it manually, or copy and paste it from a spreadsheet. -- See if Courier font will do it. Most other fonts do proportional spacing i.e. the letter m is wider than an l. In Courier (maybe teletype, typewriter and a few other fonts) use the same width of space and thus will line up columns from row to row. -- Don Vancouver, USA, a great city in one of the 45+ countries in America! "simonh" <si...

12.2.0 will not install
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm trying to install 12.2.0 on a MacBook with System 10.5.7. Everything downloads. It runs through the install process until it gets to destination select. No destination disk shows. Now what do I do? Do you have Mac Office 2008 [v12] installed & updated to at least 12.1.0? There isn't enough info about your current installation. Regards |:>) Bob Jones [MVP] Office:Mac On 7/20/09 6:33 PM, in article 59b78758.-1@webcrossing.caR9absDaxw, "bytwerk@officeformac.com" <bytwerk@officeformac....

opening text file converts numbers to scientific notation
If I open a text file containing 13-digit barcode numbers for stock using Excel 2007, the numbers are converted to scientific notation. I don't have the option to specifiy that I want 13 digits with no decimals, but I believe this was possible in earlier versions. Is there a workaround or a preference i am missing? On the "Home" tab in the "Cells" group, "Format", then "Format Cells", "Number" tab, "Number", zero decimal places. Some hints on 2003 to 2007 command mapping: http://office.microsoft.com/en-us/excel/HA1...

How do I make a negative balance automatically appear in red?
I have created a budget worksheet. I want a positive balance to appear in black (got this one) and a negative balance to appear in red. How do I set up the negative balance to appear in red? In EXCEL 2007:- 1. Highlight the range that you wish your formatting to apply to (for example C 1 to C 5). 2. Home / Conditional Formatting / New Rule / select:- Format only cells that contain - in here by clicking it. 3. Then change:- Format only cells with: - to read:- less than 0 4. Click on:- Format - and change the:- Color: - to red. Hit OK and...

Faulting application outlook.exe version 11.0.8169, stamp...,faulting module mso.dll....
I am running Win XP pro, MS Office Outlook 2003 sp 3 and our exchange server is server 2000. I am consistantly getting this error (in the subject line) when using outlook. I can be opening, sending, replying too, deleting, moving a message to another folder and I get kicked out of outlook. The dialog box I get sais, 'Microsoft office Outlook has encountered a problem and needs to close.' and has a check box with the option to restart MS office outlook when you select either send error report or dont send. The message above in the subject line is what is generated in the event log....