Results 1 to 3 of 3

Conditional Formatting based on a ratio

Threaded View

kmlloyd Conditional Formatting based... 02-24-2010, 02:53 PM
shg Re: Conditional Formatting... 02-24-2010, 03:09 PM
kmlloyd Re: Conditional Formatting... 02-24-2010, 03:16 PM
  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.

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