+ Reply to Thread
Results 1 to 2 of 2

Changing text color once entered based off a value of another cell.

Hybrid View

  1. #1
    Registered User
    Join Date
    03-09-2015
    Location
    VA
    MS-Off Ver
    Office 2013
    Posts
    20

    Changing text color once entered based off a value of another cell.

    Capture.PNG

    Hello everyone.. I have a "Standard" Column and an "Actual" column..I want to configure this so if the actual is punched in the number in the actual column once entered changes based off the value in the standard.. So for instance.

    I want if the actual is below 25, Green Text, if its 5 or less above the standard..Yellow and if its 5 over the standard then Red.

    This should be done in conditional formatting correct?
    Thanks!

  2. #2
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Re: Changing text color once entered based off a value of another cell.

    Please see example solution attached, you need to create conditional rules formatting.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting (changing color) in one cell based on text in two cells
    By Chadyoung1 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-14-2013, 04:26 AM
  2. Changing text color of cell based on character
    By -Fate- in forum Excel General
    Replies: 8
    Last Post: 06-02-2010, 03:37 PM
  3. Changing text color based on a limit within the cell
    By jessetrunk in forum Excel General
    Replies: 1
    Last Post: 02-02-2010, 09:49 AM
  4. Changing cell color once text is entered
    By KRayKeeling in forum Excel General
    Replies: 1
    Last Post: 08-05-2007, 11:36 AM
  5. Changing chart color based on number entered
    By confused chart girl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2005, 01:05 PM

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