+ Reply to Thread
Results 1 to 4 of 4

font colour change based on adjacent cell value

  1. #1
    Registered User
    Join Date
    06-17-2015
    Location
    India
    MS-Off Ver
    Office 2007
    Posts
    2

    font colour change based on adjacent cell value

    Book1.xlsx

    Pls help how to change column b font color based on column a values, as given in the attached file.

  2. #2
    Registered User
    Join Date
    01-10-2014
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: font colour change based on adjacent cell value

    hi

    can you explian more

    what should be the condition?

    example - if column A<=100 column B should be "red"

    once we know that we can put conditional formatting and choose color

  3. #3
    Registered User
    Join Date
    06-17-2015
    Location
    India
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: font colour change based on adjacent cell value

    for each cell in column a the value will be different
    example
    1
    12
    123
    1234

  4. #4
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: font colour change based on adjacent cell value

    Lookup information on Conditional Formatting where colour can be changed based on cell value "between" or "less than" values. This is easy to setup, HOME tab, CONDITIONAL FORMATTING selection, set new rule, select cell where value is based on, set colour format for range of values.

+ 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. Replies: 2
    Last Post: 02-22-2015, 11:52 AM
  2. Change Cell Value based on Colour of Adjacent Cell
    By pgfindlay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2013, 12:23 AM
  3. Use VBA to change font colour of a cell based on its own value (date)
    By grahamc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2012, 03:57 PM
  4. Replies: 2
    Last Post: 06-07-2011, 07:00 AM
  5. Replies: 2
    Last Post: 10-10-2008, 11:24 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