+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting to highlight both rows

  1. 09-04-2020, 01:34 PM #1
    windrain
    windrain is offline
    Registered User
    Join Date
    01-16-2014
    Location
    washington
    MS-Off Ver
    Excel 365
    Posts
    66

    Conditional formatting to highlight both rows

    Hello,
    I am trying to use conditional formatting to highlight multiple rows.
    My attached sample shows the first table what is happening and the 2nd table what I want to happen.
    If there is no date in column B (blank cell) then I don't want anything highlighted.
    Second I would like both rows to highlight if 2 conditions are met, In column H the cell matches the cell below it. and in column J the cell matches column K row right below.
    So Column H row 7 matches row 8 and column J7 matches Column K8 So I would like B7:K7 and B8:K8 to be highlighted.

    I really hope this makes since! Any help would be appreciated!
    Thank you
    Stacey
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-04-2020, 03:35 PM #2
    etaf
    etaf is online now
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,737

    Re: Conditional formatting to highlight both rows

    I dont have a J - the data stops at H

    So Column H row 7 matches row 8 and column J7 matches Column K8
    G7 = H8
    and
    f7 = F8

    using a rule, which may not work for all possibilities - BUT

    =OR(AND($B23<>"",$G23=$H24,$F23=$F24),AND($B22<>"",$G22=$H23,$F22=$F23))
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 09-04-2020, 05:21 PM #3
    windrain
    windrain is offline
    Registered User
    Join Date
    01-16-2014
    Location
    washington
    MS-Off Ver
    Excel 365
    Posts
    66

    Re: Conditional formatting to highlight both rows

    Wayne
    sorry for the mix up on the columns, however, your formula works perfect for what I need!
    Thank you so very much!
    Stacey
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. highlight the rows in RED using conditional formatting according to the selection in the v
    By ghost306 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-20-2022, 03:56 AM
  2. Conditional Formatting to Highlight Rows Where Columns C to G Contain Text
    By sporenboss in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-09-2019, 01:54 PM
  3. Conditional Formatting To Highlight Rows
    By melbin in forum Excel General
    Replies: 1
    Last Post: 08-14-2018, 08:41 PM
  4. Using conditional formatting to highlight duplicate rows (VBA?)
    By RedditGold in forum Excel General
    Replies: 2
    Last Post: 02-14-2017, 04:00 PM
  5. Conditional formatting to highlight rows that repeat
    By bayala87 in forum Excel General
    Replies: 1
    Last Post: 09-24-2015, 01:50 PM
  6. [SOLVED] Conditional Formatting to Highlight Entire Rows
    By christopherw34 in forum Excel General
    Replies: 4
    Last Post: 05-10-2012, 04:12 PM
  7. highlight rows / columns using VBA & Conditional Formatting problem
    By MARKSTRO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2010, 12:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1