+ Reply to Thread
Results 1 to 5 of 5

Text Color Change - Cell by cell basis - when budget is reached

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Text Color Change - Cell by cell basis - when budget is reached

    Hi All!

    New guy to the forum. I'm a business/application consultant for ERP software, and generally pretty solid when it comes to excel. However, I've come across a question for a personal sheet that I can't seem to solve.

    In my personal budget worksheet, I'd like to set a budget on a cell-by-cell basis. When the budget is hit, I'd like the text color (or cell color) to change.

    I.E. Cell D14 has a budget of $200. When I enter $200 in the cell, the text turns from black to red.

    I've searched through google with no luck. I have mildly searched this forum, but haven't found my direct answer - I have come pretty close though, in other languages

    Any help?

    TIA!
    Last edited by bcart82; 01-20-2009 at 03:59 PM. Reason: Solved

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Highlight the cell, click FORMAT > CONDITIONAL FORMATTTING > Condition1:

    Cell Value Is - Greater than or equal to - 200

    Click Format and set font color to red.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    10-23-2008
    Location
    ohio
    Posts
    13
    you should be able to use the conditional formatting to make the cell by cell colors change. There may be an easier way to do this but thats how i would do it.

  4. #4
    Registered User
    Join Date
    01-20-2009
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003
    Posts
    2
    Quote Originally Posted by JBeaucaire View Post
    Highlight the cell, click FORMAT > CONDITIONAL FORMATTTING > Condition1:

    Cell Value Is - Greater than or equal to - 200

    Click Format and set font color to red.
    Ahhhhh! So happy

    Thank you very much!

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Quote Originally Posted by bcart82 View Post
    Ahhhhh! So happy

    Thank you very much!
    Glad it helped.

    If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

+ 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