+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting for number format

  1. 03-02-2014, 06:21 PM #1
    Copenworld
    Copenworld is offline
    Registered User
    Join Date
    03-01-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    14

    Conditional formatting for number format

    Can I use conditional formatting to determine if a number in a cell is displayed as a normal decimal or scientific?

    So a number of 1000 or above will be changed to scientific notation with 4 significant figures.

    The conditional formatting just seems to be about colour/shading/icons
    Reply With QuoteRegister To Reply
  2. 03-02-2014, 06:26 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Conditional formatting for number format

    Yes, it can be changed to scientific format. When you are choosing your formatting options, click on the Number tab ...


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 03-02-2014, 08:35 PM #3
    Copenworld
    Copenworld is offline
    Registered User
    Join Date
    03-01-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Conditional formatting for number format

    Quote Originally Posted by TMShucks View Post
    Yes, it can be changed to scientific format. When you are choosing your formatting options, click on the Number tab ...


    Regards, TMS
    Cheers, sussed it.
    Reply With QuoteRegister To Reply
  4. 03-02-2014, 08:49 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Conditional formatting for number format

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Format a cell for Number closest to the original number but is higher in value
    By tm1274 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-13-2013, 12:51 PM
  2. [SOLVED] Need conditional format to check prior sheet for a given number and change format if found
    By Bearded Dan in forum Excel General
    Replies: 3
    Last Post: 05-15-2013, 12:16 AM
  3. Make conditional formatting Macro dependent on cell number format
    By jbyrne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2010, 10:26 AM
  4. Conditional Formatting Code - Deletes Wrong Conditional Format
    By RSpecianJr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2010, 10:53 AM
  5. How to create a conditional format that changes the number format
    By tmbo in forum Excel General
    Replies: 0
    Last Post: 08-23-2006, 01:01 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1