+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting greater than 100%

  1. #1
    Registered User
    Join Date
    06-23-2008
    Posts
    29

    Conditional Formatting greater than 100%

    In a job workbook, Row 51 is to be filled with reimbursable expenses every month, beginning in Column E and continuing through Z.
    The numbers that are entered in that row need to be marked up 10%.
    Is it possible to format the row in such a way that each number entered in each cell is automatically marked up 110%, or multiplied by 1.1? thanks in advance.
    Last edited by henro8; 10-08-2008 at 04:57 PM.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Maybe an event macro

    Right click the sheet tab > select view code > paste in the below and enter a value in row 51

    Please Login or Register  to view this content.
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    06-23-2008
    Posts
    29

    Conditional Formatting...

    Wow!!
    Thank you VBA Nood for the quick reply and great solution. How do you do that? maybe this is too much to ask, but i'd love to know what that VBA code means, and if you just came up with that.
    either way, thanks so much!

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Similar questions come up all the time.

    This bit of code is for the conditions and exit sub if not meet

    Please Login or Register  to view this content.
    So will only work if one cell and the target row is 51 and target column is less than 26 e.g A to Z

    This make sure the event is only triggered once and true added at end to turn it back on
    Please Login or Register  to view this content.
    This checks that it's a value and if it is and meet all the conditions above * the target cell value by 1.1

    Please Login or Register  to view this content.
    Similar idea here
    http://www.mcgimpsey.com/excel/accumulator.html

    HTH

    VBA Noob

  5. #5
    Registered User
    Join Date
    06-23-2008
    Posts
    29

    Conditional Formatting...

    thanks for the explanation and the link. i think i'm going to have to hit the books a bit to really get a hold on this stuff.

    best,
    henry

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    It takes time to learn. A good source is reading the links below and the posts in programming.

    VBA Noob

+ 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. Excel 2007 : Conditional Formatting drag
    By Scott27 in forum Excel General
    Replies: 3
    Last Post: 04-25-2013, 09:15 AM
  2. Excel 2007 conditional formatting bug
    By jmessina in forum Excel General
    Replies: 0
    Last Post: 04-28-2008, 09:09 AM
  3. Conditional Formatting if greater than zero
    By jkpha in forum Excel General
    Replies: 2
    Last Post: 10-31-2007, 01:50 PM
  4. Conditional Formatting Greater than surrounding Cells
    By tmiller in forum Excel General
    Replies: 1
    Last Post: 03-30-2007, 12:15 PM
  5. Conditional formatting for the greater of 7 cells
    By guest123 in forum Excel General
    Replies: 8
    Last Post: 01-15-2007, 01:39 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