+ Reply to Thread
Results 1 to 3 of 3

highlighting cells in row based on specific cell value

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Harrogate, England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Question highlighting cells in row based on specific cell value

    Hi there
    I can't seem to get this to work. I am looking to highlight cells L to S based on the value in cell J. If the stock in cell J is more than or equal to cell F I want cells L to S to be pink.

    For some reason it is skipping some cells and when I go back to conditional formatting to apply it to the rest of the table the formula looks strange and it does not work on the other rows.

    I am sure I have missed something basic but can't for the life of me work it out.
    I had tried as the formula =if(J2>=F2) but that is rejected. I have also tried =F2=<J2 which works but doesn't.

    all suggestions welcome

    thanks

    Monika
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: highlighting cells in row based on specific cell value

    Try

    in CF

    =$J2>=$F2

    Applies to:

    $Ll$2:$S$1000
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-02-2012
    Location
    Harrogate, England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: highlighting cells in row based on specific cell value

    John you are a star!

    Worked a charm

    thanks

    M

+ 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. row highlighting specific cells
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2015, 01:33 PM
  2. Replies: 1
    Last Post: 11-12-2014, 10:57 AM
  3. [SOLVED] Highlighting Cells if Specific Data Appears in Adjacent Cells
    By vinceancona in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2014, 06:33 PM
  4. VBA auto-highlighting specific cells
    By Houseofnerd in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-22-2011, 03:41 PM
  5. Highlighting or deleting specific cells
    By JoshD75 in forum Excel General
    Replies: 8
    Last Post: 05-16-2009, 01:54 PM
  6. Highlighting Specific Cells
    By warby23 in forum Excel General
    Replies: 3
    Last Post: 02-11-2009, 06:58 PM
  7. Highlighting Specific Cells
    By mrj1701 in forum Excel General
    Replies: 3
    Last Post: 08-29-2005, 05:05 PM

Tags for this Thread

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