+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Conditional formatting cell color based on text

  1. 07-19-2012, 02:38 AM #1
    herukuncahyono
    herukuncahyono is offline
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Conditional formatting cell color based on text

    Hi,
    I try to work with conditional formating with rules :
    1. If text in cell is "20 feet"….the cell color is yellow
    2. If text in cell is "40 feet"….the cell color is Green
    3. If text in cell is "50 feet"….the cell color is Red

    thanks in advance,
    regards
    herukuncahyono
    Attached Files Attached Files
    Last edited by herukuncahyono; 07-19-2012 at 02:59 AM.
    Reply With QuoteRegister To Reply
  2. 07-19-2012, 02:41 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Conditional formatting cell color based on text

    What if it's 30 feet?
    Reply With QuoteRegister To Reply
  3. 07-19-2012, 02:44 AM #3
    herukuncahyono
    herukuncahyono is offline
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Re: Conditional formatting cell color based on text

    hi zbor,
    actually its just "sample" text... not a number I can change it to another name
    Thanks
    Reply With QuoteRegister To Reply
  4. 07-19-2012, 02:53 AM #4
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Conditional formatting cell color based on text

    Look at this picture:
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  5. 07-19-2012, 02:59 AM #5
    herukuncahyono
    herukuncahyono is offline
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Re: Conditional formatting cell color based on text

    wow... thanks..zbor
    the problem is resolved
    regards
    herukuncahyono
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1