Results 1 to 5 of 5

Excel 2007 : Formula to change text color based on value?

Threaded View

  1. #1
    Registered User
    Join Date
    11-01-2010
    Location
    Planet, Earth
    MS-Off Ver
    Excel 2010
    Posts
    11

    Formula to change text color based on value?

    Given cell A1 = 10, how would I construct a formula that says: if Cell A1>5, then make it *red*, but if cell A1<5, then keep it black?

    e/ and also, how do I create a formula that basically says, if cell A3 has the words "a, b, c" then "x", OR if cell A3 has the words "d, e, f" then "y"?

    Thanks
    Last edited by NvrEvrGvUp; 11-01-2010 at 03:23 PM.

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