how do i make a cell turn red if value is less than 0?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - code does not work anymore Hello Excel 2002 - I have a spreadsheet that I rename every month with the currents month's name,( e.g. Sales for July 2008 ) and has a worksheet for each work day of the month and a summary tab at the end. I've been using the following code but the code does not work anymore . above the code first box is worksheet second box is Selection change Private Sub Worksheet_SelectionChange(ByVal Target As Range) With ActiveSheet newname = Application.WorksheetFunction.Text(Range("J1"), "mm-dd-yy") ActiveSheet.Name = newname End With End Sub thanks in advance Tag: how do i make a cell turn red if value is less than 0? Tag: 802578
  - 2
    - Is there a macro to... Is there a macro that would make it possible to lookup a certain name in a column and anytime it finds that name it will copy a range of cells and paste it into another worksheet? I.E. anytime the name Jim Smith is found in the range A5:A200 it returns a range of cells next to it...if Jim Smith was found in A5, it would copy cells C5:FN9 and paste them in a specified location on another sheet Right now I have it copying all colmns from the master sheet and if the name is not assigned to that project it will return a 0, then I have a macro to hide all rows that equal 0. Is there a better way to do this? Any hints on the best way to do this? Thanks! Tag: how do i make a cell turn red if value is less than 0? Tag: 802576
  - 3
    - How to combine information from multiple rows into one Hi, I have a spreadsheet with multiple (duplicate) rows which I would like to combine into one. The spreadsheet lists name/address of a customer and also anyone else who may be living with them in the same property. I would like to mail merge the file and send a letter to each customer listing who we think lives in the property. Here is an example: Current file: Mr Peter Smith, 1 Nowhere Street, Amy Smith Mr Peter Smith, 1 Nowhere Street, Tracey Smith Mr Peter Smith, 1 Nowhere Street, Tim Smith The new file should show 1 row as: Mr Peter Smith, 1 Nowhere Street, Amy Smith, Tracey Smith, Tim Smith Tag: how do i make a cell turn red if value is less than 0? Tag: 802572
  - 4
    - Reassign built-in shortcut keys in excel 2007 Hi there, how can I reassign (rename) built-in shortcut keys in excel 2007? For example I would like to reassign the CTRL+F (currently assigned to "bold" in the Danish version) to CTRL+B (currently assigned to "Find"). Cheers Tag: how do i make a cell turn red if value is less than 0? Tag: 802570
  - 5
    - dates and conditional formatting I have a spreadsheet (excel 2003) that has the month in column A2 and the days in column b1, c1 etc. Please see the example below. I would like to use conditional formatting to identify ,by fill color, weekends in the appropriate cells, for example Jan 5th and 6th. I am very perplexed. Any help would be much appreciated. Thanks. a b c d e f g h i j etc 1 2 3 4 5 6 7 8 9 Jan Feb JH Tag: how do i make a cell turn red if value is less than 0? Tag: 802569
  - 6
    - Excel VBA Coding for Printing Hello Could someone help on this? I like to put an object on an Excel sheet. When I click it it should print a selected range. I tried a macro but I could go up to the pre view level only. Thank You M Varnendra Tag: how do i make a cell turn red if value is less than 0? Tag: 802563
  - 7
    - Graph Data not displaying Hi, I have a range of 4 values in a spreadsheet and when I select them for a bar graph I am getting the graph with no bar displayed. The cell references are correct in the series value tab. I have tried re-entering the data but no joy. Anyone any ideas? All help greatfully accepted. Davie Tag: how do i make a cell turn red if value is less than 0? Tag: 802559
  - 8
    - print/preview problem before saving an edited excel worksheet Hi, I am the Office 2000 user. I encounter problem with printing an excel worksheet each I edit the contents without saving. Here is the comment message appeared each time I press the print / preview button: "To print, it is necessary to overwrite the content. Do you want to overwrite?" I could only print or preview if I click yes. Please advise how to fix this. Thanks. Tag: how do i make a cell turn red if value is less than 0? Tag: 802554
  - 9
    - Seperating numbers from text Hi, I am working on an excel file which has a column that contains product names + serial numbers. Dont know how but someone combined that data. they used to be in different columns but now they are in same column and have no spaces between them. cells have names like this, productname1345 is there any easy way to scan through the coulmn and at least seperate the data like productname 1345 after this step i think i can handle it:) thanx for help. Tag: how do i make a cell turn red if value is less than 0? Tag: 802552
  - 10
    - Correlations, Group By Type? I have data for several different types of land Variable1 Variable2 Variable3 TypeOfLand 30 250 300 Desert 40 670 200 Forest 10 30 400 Forest 20 500 800 Arctic 20 180 270 Desert .... I'd like to know if there's a way using PivotTables or any other function to product the following automatically CorrelationBetweenVar1and2 CorrelationBetweenVar2and3 CorrelationBetweenVar1and3 Desert Forest Arctic Swamp Lakeside ... In other words, I'd like to run a correlation between two variables, but I'd like for it to be grouped by type. Will be very grateful for any input! Regards, Sak Tag: how do i make a cell turn red if value is less than 0? Tag: 802551
  - 11
    - how to activate the scrolling within the worksheet? i cant able to scroll the worksheet using the mouse scroll action. now im scrolling using the vertical scroll bar only.give some ideas over this problem Tag: how do i make a cell turn red if value is less than 0? Tag: 802550
  - 12
    - Excel - printing specific areas Hi, my name's Gabriella. I've been working with Microsoft Excel to build a customer database. Each column is something else - address, city, zip code, phone number, job done, date the job was completed and name. I didn't put any formulas in, nor did I mess with anything that I don't know about within Excel - namely everything. This is where my question comes in. Say I want to print a list of people who've had jobs done in a specific city, or in a specific year. Is there a way to print that without having to go through the whole file and picking them out with ctrl+click? Is there some kind of formula, etc.? I know close to nothing about Excel's special features, so any help would be greatly appreciated. Thanks! :) -Gabriella Tag: how do i make a cell turn red if value is less than 0? Tag: 802547
  - 13
    - How do i convert a date into 3 seperate columns? I have a spreadsheet with dates shown as DD.MM.YYYY in text in a single column but I would like this to be represented as 3 seperate columns. One for day, one for month and one for year. Does anyone know a formula or command to do this? Many thanks, Tony Tag: how do i make a cell turn red if value is less than 0? Tag: 802544
  - 14
    - Changing column headers from alphabetical characters to numbers? I have inherited a spreadsheet that uses column headings in numbers as well as the rows. How can I reinstate the column headings to alphabetical characters? Tag: how do i make a cell turn red if value is less than 0? Tag: 802543
  - 15
    - fill combobox depending on selection from another combobox Hi all, I have been making a userform and so far all is great thanks to al the posts here, but, i can't find anything to help me with this problem. I have put 3 comboboxes on my userform, The first one i want to fill from a list. The second one i want to fill from a list depending on what was selected from the first combobox. And the third filled depending on selection from second. then all three selections put on a worksheet in seperate columns i hope this makes sense as i am only new to this. many thanks in advance Ad Tag: how do i make a cell turn red if value is less than 0? Tag: 802539
  - 16
    - Lookup unsorted list I have a very simple two column list. Col-A is "Products" col-B is "Date Purchase". Col-A is un-sorted and various products are repeated several times. I want a lookup formula that would tell me the most recent date when a particular product was purchased. If col-A was sorted ascending, I could use =LOOKUP(1E+100,INDEX(A2:B8,MATCH(A12,A2:A8,1),0)). Can someone please help. Tag: how do i make a cell turn red if value is less than 0? Tag: 802533
  - 17
    - Dynamic Array (multiple columns) Question I'm trying to create a dynamic array of data. I had previously dimensioned at the top of my sub the following: Public ItemArray(10,7) As Variant This gets me what I want, but only for 10 entries. I may actually have 50 entries. How do you dimension an array such that the amount of entries changes / is dynamic? The array is currently inside of a loop for items, and I want the array to update as below with each item. Hopefully this is enough information to piece together what I'm looking for. Thanks, Neil ItemCount = ItemCount + 1 ItemArray(ItemCount, 0) = ItemName ItemArray(ItemCount, 1) = AAvariable ItemArray(ItemCount, 2) = BAvariable ItemArray(ItemCount, 3) = CAvariable ItemArray(ItemCount, 4) = DAvariable ItemArray(ItemCount, 5) = EAvariable ItemArray(ItemCount, 6) = FAvariable ItemArray(ItemCount, 7) = GAvariable Tag: how do i make a cell turn red if value is less than 0? Tag: 802520
  - 18
    - Stop my references cancelling Hi, got a convoluted one (at least by my low standards). Using Excel 2003. I need to set up finance reports that total data using 3 criteria. To get the data, I export a report from my finance system to a spreadsheet, which I then copy into a blank (but pre-named) worksheet in the same workbook. I then "tidy up" this spreadsheet with a simple macro to delete blank rows/columns and add some columns with conditional arguments that helps sort out different types of transaction types. In the reports I'm using the following function: =SUMPRODUCT(--('Report'!V2:V30000!="S"),--('Report'!M2:M30000!="<code>"),('Report'!H2:H30000!)) Where: "S" is one of my added conditional arguments that identifies certain transaction types; <code> is the finance project code I'm reporting on; and H2:H30000 is the amounts I want to add up. Now, this formula works just fine - provided the data's already in the cells. Trouble is that I need these to stay just as they are when I then remove the original data - remember, I need to copy this in AFTER this is all set up. What I'm trying to achieve is a workbook to produce task reports (for about 30 tasks) that requires only we paste the raw data into the blank template, run my little macro and hey presto, everything else updates. I've looked at INDIRECT, but it doesn't seem to like array references. I can't seem to stop Excel automatically updating the reference any other way. Any help would be awesome. Tag: how do i make a cell turn red if value is less than 0? Tag: 802518
  - 19
    - Countif and Hi All, How I count then no. of occurances in following condition Status Speed Harsh Braking 5 Driving 15 Harsh Braking 12 Harsh Braking 35 Harsh Braking 40 Driving 12 Harsh Braking 4 Harsh Braking 0 Driving 15 How I can count the No. of harsh Braking if speed is more then or equal to 10. Thanks Tag: how do i make a cell turn red if value is less than 0? Tag: 802516
  - 20
    - Headers and Footers in Excel 2007 I have a worksheet that contains 69 pages. I need a custom footer on each of the pages. I know in Word, you could simply unselect "same as previous". However, I can't find any information anywhere. Any help is appreciated. Tag: how do i make a cell turn red if value is less than 0? Tag: 802509
  - 21
    - How can I open .wk4 file with Excel 2007? How can I import/open/edit .wk4 file in excel 2007? Tag: how do i make a cell turn red if value is less than 0? Tag: 802508
  - 22
    - REMOVE CERTAIN LINES IN A PIVIOT TABLE My worksheet is 350lines long and growing. i've created a pivoit table but want certain lines to be ignored. e.g items that have been invoiced, or lines that qualify a certain date range. Is there a way of doing this? All suggestions are greatfully welcome -- Browny Tag: how do i make a cell turn red if value is less than 0? Tag: 802507
  - 23
    - Meeting 12 formatted conditions Cells C2:C13 has JAN - DEC. If todays month is between the 1 - 31 of Jan I require the previous month â??DECâ?? conditionally formatted with a color that I specify from the color pallet. If todays month is between the 1-28 or 29th of Feb I require the previous cell month â??JANâ?? also conditionally color formatted. As conditional formatting only allows you to set a maximum of three conditions, how do I format all the months in C2:C13 the same way? Tag: how do i make a cell turn red if value is less than 0? Tag: 802505
  - 24
    - How do I Subtract 6 months off a date in excel Hi Just wanting to subtract 6 months off any date, and present in the format of a date. Cheers Tag: how do i make a cell turn red if value is less than 0? Tag: 802501
  - 25
    - How to calculate Average Hi I have data in my sheet as Row# Column A Column B Column C 1 20 0 20 2 Row # 2 has some other data 3 row # 3 has some other data 4 21 20 15 5 row#5 has some other data 6 20 0 15 ---------------------------------------------------------------- 8 Total- 61 20 50 ---------------------------------------------------------------- I want to take the average of c1, c4, c6 with the condition that cell c1 should be counted in average if cell a1>0 or a8>0, similarly cell c4 should be counted in average if cell a4>0 or a8>0 Thanks Tag: how do i make a cell turn red if value is less than 0? Tag: 802498
- Next
  - 1
    - Using VB Copy Entire Row but formulas and formats only no values I have a workbook called tracker that adds new records from a workbook called data. When I add a new record I want to copy the formulas and formatting from the row above and paste them into the empty row. Every time I try it copies the values as well. please help Tag: how do i make a cell turn red if value is less than 0? Tag: 802496
  - 2
    - how can I Delete data in a spread sheet and keep formulas how can I Delete data in a spread sheet and keep formulas Tag: how do i make a cell turn red if value is less than 0? Tag: 802494
  - 3
    - Excel Changes Text Cells to Number Cells When Importing XML I have over a thousand xml files that I need to import into Excel. One of the attributes in each xml file is a number that varies in length but generally exceeds Excel's 15 significant digit limitation. I format that column as text, but when I import the xml files, all the values in that column become numbers with the trailing zeroes. I do not have to do any calculations on the values. Storing them as text works fine. Does anybody know how I can preserve that column as text and store the original value as it's being imported? I don't usually have Internet access at work, but I will respond to any responses as soon as I can. Tag: how do i make a cell turn red if value is less than 0? Tag: 802492
  - 4
    - why does the highlighter independently jump to another cell when I try to enter data in a cell thank you Tag: how do i make a cell turn red if value is less than 0? Tag: 802486
  - 5
    - Is there a BETWEEN function? How do you test if a number is equal to or BETWEEN two other numbers, rather than greater than or equal to the smallest and less than or equal to the biggest. Reason being, the smaller number and the larger number may swap cell addresses at times. Thanks, all. Arlen Tag: how do i make a cell turn red if value is less than 0? Tag: 802485
  - 6
    - Pivot version issue-riv hi peeps i built a pack in excel 2003 and have a small pivot within it. i emailed this pack to another user who has excel 2000 when the pack arrives and he opens it the pivot table is blank i thought this maybe because of his system so emailed to another user who again has excel 2000 and the same thing happened is this a simple case of diffrent versions if so when i saved the pack in excel 2003 to be of older version type why did this not sort this problem? im in a bit of a dilema as this new pack sorts out a serious problem with the current process but if it cant be fixed then the issue will have to be worked around causing more time than it should. can anyone help? thanks Tag: how do i make a cell turn red if value is less than 0? Tag: 802483
  - 7
    - pivot reporting wrong info-riv hi peeps having an issue with my pivot tables was wondering if anyone new how to fix. my pivot tables were created from my source data and worked fine but now after i have refreshed them a few times to collate the new data its started to report things wrong i.e codes linked to products become mixed or brands of the products are linked to the wrong products. currently to fix this i create a new pivot then paste over the old. but this is time consuming and i dont want to have to train others on how to do this maintinence work. does anyone have any ideas whats wrong? or how to fix this? thank you Tag: how do i make a cell turn red if value is less than 0? Tag: 802481
  - 8
    - Named Range Used in Formula Error Formula =a*b*MONTH Results in error if Named Range is picked up from a drop down box eg: Jan set of values Feb set of values Putting named range in formula directly works fine. Point to a cell called month where users select the appropriate month yields errors How do I get the range values passed correctly to the formula if the drop down box is named MONTH? Where Month = Drop Down and Month is a named range Workarounds?? Tag: how do i make a cell turn red if value is less than 0? Tag: 802458
  - 9
    - View Questions and Answer to questions I created I forgot to check the box to "notify me of replies" and I can not find my question to see any responses. is there a way to see my history of my questions asked? -- Thanks for the help in advance Tag: how do i make a cell turn red if value is less than 0? Tag: 802457
  - 10
    - Dynamically populate a Date pulldown menu? I am trying to make charts based on a range of dates specified by the user. I am trying to use pull-down menus for both the start and end date that allow the user to choose Month, Day and Year. When the user chooses all three, a fourth cell with =DATE() should gather it all together. But it is surprisingly frustrating. First off, how do you populate the Month list with Jan, Feb, Mar...that equal 1, 2, 3 and not 1/1/1900, 1/2/1900, 1/3/1900, etc...(that ruins everything). I've tried =MONTH(), and then I get 1, 32, 64, 96...no good as well. Second, how can your list know that Feb 2007 only has 28 days, so gray out days 29-31? Third, is there a much better way for people to choose dates? I've seen floating calendar applications, but those seem complex. Experts? Thank you for your time. Arlen Tag: how do i make a cell turn red if value is less than 0? Tag: 802456
  - 11
    - Shading cells whenever they change Months How do I conditionally format a cell that whenever the cell Changes to Jan, Mar, May, Jul, Sep or Nov shades â??Blueâ?? and every other month in between shades â??Greenâ??? Tag: how do i make a cell turn red if value is less than 0? Tag: 802449
  - 12
    - sumproduct Hi, I have a formula looks like this:=SUMPRODUCT(--(M15:M252=J158),(L15:L252))+SUMPRODUCT(--(M15:M252=J158),(N15:N252)) How do I simplify to sum L15:L252 and N15:N252 Thanks. Tag: how do i make a cell turn red if value is less than 0? Tag: 802444
  - 13
    - tying 2 Excel spreadsheets together I have 2 excel spreadsheets, one is a master agent list with agent number, address, city, state zip. Second one is a spreadsheet with agent number and other information on it. I need to pull the addresses from the first spreadsheet to the second spreadsheet. the common denominator is the agent number. Can this be done?-- Mary C Tag: how do i make a cell turn red if value is less than 0? Tag: 802443
  - 14
    - Forecast Formula Help I'm looking to write a formula that matches two criteria before calcualting a forecast. I tried using a IF AND function but the Forecast function itself will only calculate based on one X value. I want the X value only if it returns a TRUE matching two criteria in two different columns first. Is there a way to calculate this? Tag: how do i make a cell turn red if value is less than 0? Tag: 802441
  - 15
    - Disable autoformat of "true" and "false" text Hi, When I enter the words "true" or "false" by themselves in any excel cell (I am using 2007 Pro), they are automatically centered and displayed in upper case. When included in a sort (e.g., A-Z ascending) in this format, they always appear at the bottom of the sort. I am aware of some workarounds like preceding the text with an apostrophe as in 'true or 'false or just adding an empty space right after it. But is there a more direct way of simply turning off this feature? I can't seem to find any when I go to excel options. Thanks again for your valuable help. Tag: how do i make a cell turn red if value is less than 0? Tag: 802428
  - 16
    - Look Up Help Needed Let's say I have a data table where the top row contains this month's dates and the row beneath contains a bank balance. I update the bank balance row each day with the prior day's balance. Also, there is a column to the far right called 'Daily Total.' See below: Daily Total Dates| 7/1 7/2 7/3 etc. Value| $1 $4 $5 etc. ? How can I have the "Daily Total" column return the most recent date's bank balance? Note, it is possible that the balance could be zero. Tag: how do i make a cell turn red if value is less than 0? Tag: 802419
  - 17
    - Email excel file help I have a multiple page workbook, that is password protected. I have employees who need to be able to email an individual worksheet of the workbook as an attachment. However, because of the password protection, they can only email the entire workbook as an attachment. Any ideas how to work around this? Tag: how do i make a cell turn red if value is less than 0? Tag: 802411
  - 18
    - Excel 07 - Combining Number minus the excess wording I have numbers that represent code/state and would like to combine them in one cell (Column B) where the "xxxx". Column A starts with the code needed but I do not need the extra wording - just the first 4 numbers. Example: A B C Atlanta 00100 3000 - Bill xxxx 4930 3001 - Legal xxxx 5690 Results - I looking for 1 A B C 2 Atlanta 3 00100 4 3000 - Bill 300000100 4930 5 3001 - Legal 300100100 5690 Column A4:A5 = code (just the first 4 numbers) Column $C$3 = state Column B = formula to combine the two (code_state) Tag: how do i make a cell turn red if value is less than 0? Tag: 802410
  - 19
    - Double Conditional Formatting I have a spread sheet with two columns, D and E. Column D has either "Open" or "Closed" in the cell. Column E is a formula which calulates the difference in the current date and a given date in Column C. Column D is conditionally formatted so that the "Open" cells are red and the "Closed" cells are green. What I need to do is hilight the cells in Column E that have a value less than or equal to ZERO and the corresponding row in Column D is still labeled "Open" Thank you. Tag: how do i make a cell turn red if value is less than 0? Tag: 802409
  - 20
    - Set total amount for an equation..... I have a total dollar amount I have to stay under....not go over. I am gathering the totals from multiple cells which is a percentage from another number. is there a way to put like a cap on the total so it only calculates upto a certain number? Im not sure how to explain this without looking at it. -- Heather Tag: how do i make a cell turn red if value is less than 0? Tag: 802403
  - 21
    - Excel 07 - combining number I have numbers that represent code/state and would like to combine them in one cell (Column B) where the "xxxx". Example: A B C Atlanta 00100 3000 xxxx 4930 3001 xxxx 5690 Results - I looking for 1 A B C 2 Atlanta 3 00100 4 3000 300000100 4930 5 3001 300100100 5690 Column A4:A5 = code Column $C$3 = state Column B = formula to combine the two (code_state) Tag: how do i make a cell turn red if value is less than 0? Tag: 802398
  - 22
    - Defined Names issue Greetings, We have recently ran across an issue that may hold up our deployment due to the programming issue it causes. Here is the steps to recreate the situation in Excel 2007. 1. Create 2 basic workbooks (no macros) named wb1.xlsx and wb2.xlsx 2. In wb1 I defined a name SameName and made the scope Worksheet 3. Then I created another name SomeOtherName and kept the scope as workbook. 4. In wb2 I created a link to wb1 (=[wb1]Sheet1!$A$2). Just type the = and switch to wb1 to select the cell A2. 5. Save them both 6. Close wb1, leave wb#2 open 7. Reopen wb1 8. The defined name SomeOtherName, whose scope is workbook, has been deleted. This causes programming issues if the defined name does not exist, which in this case the workbook defined name is removed. Our Environemnt is Win XP SP2 and Office 2007 Pro Plus. Can any provide any help on this issue? -- Nick Tag: how do i make a cell turn red if value is less than 0? Tag: 802393
  - 23
    - refering to specific cell in the formula ='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1 this is a formula in the specific cell but i have more than 150 files.xlsx and i have to merge it in one sheet can any one give me a way to make this idea possiable a b c d e 1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx 2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1 3 ='C:\Documents and Settings\VENUS\Desktop\[B21]1'!$A$1 4 ='C:\Documents and Settings\VENUS\Desktop\[B3]1'!$A$1 that mean i will refer the name of the file in the furmula to the cell A1 B1 C1 etc. i have tried many ways but it doesn't run so kindly and expert tell me the way to do that with the file name and the sheet that i give (1) for it names also in the same way Tag: how do i make a cell turn red if value is less than 0? Tag: 802392
  - 24
    - Match, VLookup possible formula needed have three columns - data changes, need to find matching data if two of the match the criteria Data and Rows changes Find matching FTE data if no match enter a zero Lab & Dept stay constant Lab Dept FTE Lab Dept FTE Answers 14 10 3.04 16 10 Need 5.45 14 15 5.63 16 15 formula 0 14 40 3.39 16 30 11.3 14 100 0.19 16 40 0 14 260 6.61 16 50 5.61 16 10 5.45 16 30 11.3 16 50 5.61 Is this possible? Tag: how do i make a cell turn red if value is less than 0? Tag: 802388
  - 25
    - Edit links Hi, I would like to have the Links (edit links) update to point to the appropriate desktop location where the options sheet (the .xls file with all the drop downs) is located. Each users desktop path name is different. changed the linked file location (i thought)???: ActiveWorkbook.ChangeLink Name:="C:\Option.xls", NewName:=sPathDeskTop & "\Option.xls", Type:=xlExcelLinks opens the options file: Workbooks.Open Filename:= sPathDeskTop & "\DatVal.xls" Problem: In the Edit|Links menu the location is still "C:\" and the drop downs don't work. -- Thank you, vbcraft Tag: how do i make a cell turn red if value is less than 0? Tag: 802381

i have a list of numbers on my worksheets, inclusing some zeros. i would a
formula that means whenenver a cell just has 0 in it it will show as red.

Is this possible?

Thanks

RE: how do i make a cell turn red if value is less than 0? by JohnMoore

JohnMoore
Thu Jul 24 07:35:01 CDT 2008

Use conditional format ,,,, where cell value equals "0" ,,, format to RED

"Megglesface" wrote:

> i have a list of numbers on my worksheets, inclusing some zeros. i would a
> formula that means whenenver a cell just has 0 in it it will show as red.
>
> Is this possible?
>
> Thanks

RE: how do i make a cell turn red if value is less than 0? by Tausif

Tausif
Thu Jul 24 07:45:00 CDT 2008

1) Select all the cells that have numbers.
2) Format->ConditionalFormatting
3) Under Condition1
Cell Value is ... Equal To ... 0

Click the format button & give any format that you want. This will change
all 0's to that color/format.

HTH,
--
Tausif Mohammed

"Megglesface" wrote:

> i have a list of numbers on my worksheets, inclusing some zeros. i would a
> formula that means whenenver a cell just has 0 in it it will show as red.
>
> Is this possible?
>
> Thanks

RE: how do i make a cell turn red if value is less than 0? by Megglesface

Megglesface
Thu Jul 24 07:46:01 CDT 2008

thats great, thanks

"John Moore" wrote:

> Use conditional format ,,,, where cell value equals "0" ,,, format to RED
>
> "Megglesface" wrote:
>
> > i have a list of numbers on my worksheets, inclusing some zeros. i would a
> > formula that means whenenver a cell just has 0 in it it will show as red.
> >
> > Is this possible?
> >
> > Thanks