+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting based on percentage

  1. #1
    Registered User
    Join Date
    02-07-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    16

    Conditional Formatting based on percentage

    Hi

    I am stuck. I need a conditioning format formula please. If cell A2 is less than 50% of cell A1, then highlight red. For the life of me, it seems easy, but I cant figure it out.

    Any help would be appreciated.

    Thanks

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Conditional Formatting based on percentage

    =a2<a1*0.5

  3. #3
    Registered User
    Join Date
    02-07-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Conditional Formatting based on percentage

    Thank you so much, works like a charm

+ 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. [SOLVED] Conditional Formatting with Data Bars - Based on Completion Percentage
    By benwahchang in forum Excel General
    Replies: 9
    Last Post: 11-14-2014, 03:38 PM
  2. Replies: 2
    Last Post: 02-26-2013, 03:47 AM
  3. Replies: 2
    Last Post: 01-10-2011, 03:29 PM
  4. Conditional formatting based on a percentage difference
    By Dan27 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-13-2010, 04:53 PM
  5. Replies: 5
    Last Post: 04-04-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1