+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting based on a ratio

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-18-2009
    Location
    Winnipeg
    MS-Off Ver
    Excel 2003
    Posts
    203

    Conditional Formatting based on a ratio

    I have a cell returning a ratio based on the values in 2 other cells. The calculation is a fraction, and the formatting is a custom formatting of 0.0":1"

    My goal is a ratio of 4:1. I want the "actuals" cell to be red if it is showing 4.1:1 or more....and green if it is 4:1 or less. I know how to create conditional formatting, but because it's a ratio, I can't seem to get the right formula in my conditional formatting that will return the right colour.

    Any ideas? See attached for a very simple example.
    Attached Files Attached Files
    Last edited by kmlloyd; 02-24-2010 at 03:17 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Conditional Formatting based on a ratio

    The fact that it's a ratio doesn't matter; it's just a number. Conditional format in the usual way.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    11-18-2009
    Location
    Winnipeg
    MS-Off Ver
    Excel 2003
    Posts
    203

    Re: Conditional Formatting based on a ratio

    Quote Originally Posted by shg View Post
    The fact that it's a ratio doesn't matter; it's just a number. Conditional format in the usual way.
    Hmmm I've tried that though and it's not working. It's just returning green every time....

    I have:

    If cell value is greater than or equal to C11 then red
    If cell value is less than C11 then green

    eta: Ah ha! My "Goals" column wasn't formatted as a number.

    Thanks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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