+ Reply to Thread
Results 1 to 6 of 6

A Macro Which Makes Negative Numbers In A Selected Range Red

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    A Macro Which Makes Negative Numbers In A Selected Range Red

    Note : The macro makes the negative numbers in a selected range red.

    Why doesn't it work?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: A Macro Which Makes Negative Numbers In A Selected Range Red

    Change your code to
    Please Login or Register  to view this content.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: A Macro Which Makes Negative Numbers In A Selected Range Red

    Hello zanshin777,

    You could also consider playing around with these alternatives;

    Please Login or Register  to view this content.
    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: A Macro Which Makes Negative Numbers In A Selected Range Red

    I don't understand this statement;

    If TypeName(Selection) <> "Range" Then Exit Sub

    Because there isn't a range variable in the name of "Range" (string). Is it?

  5. #5
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: A Macro Which Makes Negative Numbers In A Selected Range Red

    Sorry. Entry duplication. My question is above.

  6. #6
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: A Macro Which Makes Negative Numbers In A Selected Range Red


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 10-12-2013, 01:01 PM
  2. Inserting negative sign into a range of numbers
    By AM Fernandez in forum Excel General
    Replies: 6
    Last Post: 04-25-2012, 11:14 PM
  3. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  4. [SOLVED] How can i put a negative sign on a range of selected cells?
    By chermaine in forum Excel General
    Replies: 3
    Last Post: 08-07-2005, 10:05 PM
  5. Ploting data with a large range including negative numbers
    By Hoochi Coochi Man in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-28-2005, 11:06 AM
  6. Replies: 2
    Last Post: 04-01-2005, 01:06 PM
  7. [SOLVED] Converting negative numbers in a range of cells to zero
    By Dede in forum Excel General
    Replies: 3
    Last Post: 01-14-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1