+ Reply to Thread
Results 1 to 3 of 3

Conditional Formating using a formula to determine what cells to format.

  1. #1
    Registered User
    Join Date
    08-17-2015
    Location
    Vancouver, WA
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Conditional Formating using a formula to determine what cells to format.

    I need help creating a formula for conditional formatting.

    I have 3 cells with 3 numbers. What I need is a formula to take the lowest number, multiply that by 1.5. This result is the MAX number the other 2 numbers can be. If any of the other numbers goes above the MAX, I need the cell to be highlighted.
    So anything: >((lowest number of the 3 cells)*(1.5))

    For example:

    My 3 numbers: 10, 13, 33. With 10 being my lowest number, that would be 10*1.5=15. Any number above 15 needs to be highlighted. In this case, the cell with 33 should be highlighted.

    Is there a way to conditionally format these cells to do this???

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Conditional Formating using a formula to determine what cells to format.

    Assume your three numbers are in the cell range A2:C2, then select A2:C2, and with Conditional Format, use the formula:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    08-17-2015
    Location
    Vancouver, WA
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Re: Conditional Formating using a formula to determine what cells to format.

    Thank you for the quick reply,
    Last edited by dpeek; 08-17-2015 at 03:52 PM.

+ 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: 1
    Last Post: 06-25-2015, 08:14 AM
  2. Conditional formatting use a formula to determine which cells to format
    By aaslezak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2015, 05:00 PM
  3. Replies: 7
    Last Post: 03-24-2015, 07:44 AM
  4. [SOLVED] Conditional Formatting to Use a formula to determine which cells to format
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-16-2013, 10:29 AM
  5. Replies: 7
    Last Post: 02-20-2013, 06:34 PM
  6. Replies: 3
    Last Post: 08-04-2012, 07:22 PM
  7. Use a formula to determine which cells to format?
    By jonvanwyk in forum Excel General
    Replies: 4
    Last Post: 06-04-2012, 11:10 AM

Tags for this Thread

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