+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting based on value in another column

  1. #1
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    407

    Conditional Formatting based on value in another column

    Hi,

    I have a value in column H7 as 2000
    I have columns M to X labeled Jan to Dec. I want to highlight in yellow values in the row M7 to X7 if they are greater than 2000!

    Then, I need to copy this conditional formatting down the columns under M to X, but under column H the values will be different, but I still want the same results, values greater than the value under column H then highlight in yellow
    I thought I had the answer but when I tried to copy down, it was making cells yellow that were clearly less than the column H value.

    Any help will be appreciated!
    ==========
    Bigroo1958
    Austin, Texas
    ==========

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,003

    Re: Conditional Formatting based on value in another column

    Hi Bigroo1958,

    can you post the file or an example of the data?

    Thanks
    Remember you are unique, like everyone else

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,341

    Re: Conditional Formatting based on value in another column

    1. highlight the range you want to apply the conditional formatting to (M7:X100...or whatever your range is)
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =M7>$B7 format fill yellow
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    407

    Re: Conditional Formatting based on value in another column

    Thanks FDibbins,

    I tried "use formula option" but I only entered in =$H7 and I was only highlighting on row, row M!
    Thanks works nicely indeed.

    Also, thanks Noboffinme, I was about to attach an example when I seen the latest post and reply, I appreciate the offer of help!

    Thanks

  5. #5
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    407

    Re: Conditional Formatting based on value in another column

    FDibbins,

    I have attached my demo sheet with dummy data.
    Why is the cell in row 10 still looking at H7 when you review the CF formula?
    Attached Files Attached Files

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,341

    Re: Conditional Formatting based on value in another column

    you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

+ 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: 0
    Last Post: 11-20-2013, 11:28 AM
  2. Macro for Conditional formatting of a column based on another column
    By surya5489 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2013, 06:24 AM
  3. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  4. Replies: 3
    Last Post: 10-29-2010, 12:52 AM
  5. [SOLVED] conditional formatting based on column
    By snax500 in forum Excel General
    Replies: 4
    Last Post: 04-27-2005, 02:06 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