+ Reply to Thread
Results 1 to 5 of 5

Conditional Format-cells with un-equal numbers

  1. #1
    AWS
    Guest

    Conditional Format-cells with un-equal numbers

    I have cells with info like 1/6 and 2/2 etc

    Is it possible to have a Conditional Format Formula that will color
    cells with un-equal numbers (1/6, 3/4 etc) Red and
    cells with equal numbers (3/3, 1/1 etc) Light Green

    _______________________________
    AWS

  2. #2
    Bob Phillips
    Guest

    re: Conditional Format-cells with un-equal numbers

    Do you mean integers and non-integers?

    if so you can use conditional formatting with formulae of

    =A2=INT(A2)

    and

    =A2<>INT(A2)

    --
    HTH

    Bob Phillips

    "AWS" <[email protected]> wrote in message
    news:[email protected]...
    > I have cells with info like 1/6 and 2/2 etc
    >
    > Is it possible to have a Conditional Format Formula that will color
    > cells with un-equal numbers (1/6, 3/4 etc) Red and
    > cells with equal numbers (3/3, 1/1 etc) Light Green
    >
    > _______________________________
    > AWS




  3. #3
    AWS
    Guest

    re: Conditional Format-cells with un-equal numbers

    "1/3" represents "One of Three"
    "2/2" represents "two of two" etc

    I want the cells with the left hand number smaller than the right
    to be shown in red, and if they match shown in green

    _______________________________
    AWS


    "Bob Phillips" wrote:

    > Do you mean integers and non-integers?
    >
    > if so you can use conditional formatting with formulae of
    >
    > =A2=INT(A2)
    >
    > and
    >
    > =A2<>INT(A2)
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > "AWS" <[email protected]> wrote in message
    > news:[email protected]...
    > > I have cells with info like 1/6 and 2/2 etc
    > >
    > > Is it possible to have a Conditional Format Formula that will color
    > > cells with un-equal numbers (1/6, 3/4 etc) Red and
    > > cells with equal numbers (3/3, 1/1 etc) Light Green
    > >
    > > _______________________________
    > > AWS

    >
    >
    >


  4. #4
    Forum Contributor
    Join Date
    05-04-2005
    Posts
    136
    in conditional formatting, put condition 1 formula is:
    =RIGHT(A1,1)=LEFT(A1,1)
    and format to green

    condition 2 formula is:
    =left(a1,1)>right(a1,1)
    and format to red.

    this assumes the data is in A1

  5. #5
    AWS
    Guest

    re: Conditional Format-cells with un-equal numbers

    That did the trick

    Thanks
    _______________________________
    AWS


    "tkaplan" wrote:

    >
    > in conditional formatting, put condition 1 formula is:
    > =RIGHT(A1,1)=LEFT(A1,1)
    > and format to green
    >
    > condition 2 formula is:
    > =left(a1,1)>right(a1,1)
    > and format to red.
    >
    > this assumes the data is in A1
    >
    >
    > --
    > tkaplan
    > ------------------------------------------------------------------------
    > tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
    > View this thread: http://www.excelforum.com/showthread...hreadid=470361
    >
    >


+ 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