+ Reply to Thread
Results 1 to 3 of 3

Formatting Text based on numeric values in the next column

  1. #1
    Registered User
    Join Date
    02-10-2009
    Location
    Shakopee, MN
    MS-Off Ver
    Excel 2003
    Posts
    14

    Formatting Text based on numeric values in the next column

    I am wondering if it is possible to format a cell that contains text - based on a number in the cell next to it. Here is what I have:

    Category......Mean
    Results.........3.3
    Morale..........3.8
    Buy-In..........4.0

    I would like the word 'Results' to display in BLACK text because the mean score is in the range 3.0-3.9 (same goes for the word 'Morale')
    I would like the word 'Buy-In' to disply in GREEN text because the mean score is in the range 4.0-5.0

    Basically, the mean scores are calculated using formulas and I would like the color of the category to change based on the mean score number.

    Is there a way to use conditional formatting to do this? Or another way to automatically make this work?

    File is attached.
    Thanks!
    Sarah
    Attached Files Attached Files
    Last edited by Grateful; 02-13-2009 at 11:14 AM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting Text based on numeric values in the next column

    cf formula is
    condition 1

    =AND($B1>=3,B1<4) black
    condition 2
    =AND($B1>=4,B1<5) green
    for yours select a34 to a40
    and use

    =AND($B34>=3,$B34<4)
    but i must point out that b37 does not = 4 it is really 3.975
    so use
    =AND(ROUND($B34,1)>=3,ROUND($B34,1)<4) then b37 wil be treated as 4
    Last edited by martindwilson; 02-12-2009 at 07:00 PM.

  3. #3
    Registered User
    Join Date
    02-10-2009
    Location
    Shakopee, MN
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Formatting Text based on numeric values in the next column

    Thank you soooo much!! This worked perfectly. Sincerely appreciate the assistance!

    Sarah

+ 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