Welcome Guest
Log In | Register )
You last visited January 17, 2017, 9:54 am
All times shown are
Eastern Time (GMT-5:00)

color matched values excel formula

Topic closed. 2 replies. Last post 7 years ago by grass34.

Page 1 of 1
PrintE-mailLink
grass34's avatar - happy

Turkey
Member #61432
May 22, 2008
37 Posts
Offline
Posted: September 14, 2009, 1:32 pm - IP Logged

This may be out of the realm, but is there a way I can have a cell(s) with text in it change to another color?
To be a little clearer. Cell H3 (but i have a small formula in cell h3) has 9 and cell A4 has the same value (9) (or number or value etc..)
i would to color red for H3 if it find matches in range A4:F4
I am probably streching the bounds of this program, but any feedback would be appreciated.

 

screenshot

    Avatar
    Iron Station, NC
    United States
    Member #74828
    May 21, 2009
    69 Posts
    Offline
    Posted: September 14, 2009, 7:52 pm - IP Logged

    I think you would need a marco to change the colors in a cell, may be able to come up with a formula in

    column I that would show you have a match in column H.  But need more information about what your

    trying to do.

      grass34's avatar - happy

      Turkey
      Member #61432
      May 22, 2008
      37 Posts
      Offline
      Posted: September 14, 2009, 8:01 pm - IP Logged

      i have  done my research while wait replys from LP members. thanks everyone who looked :)

      solution:

      =ISNUMBER(MATCH(TEXT(H3,"00"),A4:F4,0))