+ Reply to Thread
Results 1 to 5 of 5

Conditional Format Entire Row Based On One Cell In Row

Hybrid View

  1. #1
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,679
    Still selecting the 5 columns you can use

    =COUNTIF($A:$A,$A1)>1

    If you want both conditions to apply in the same row then you'll need to use 3 conditions

    condition 1
    =($E1=12345)*(COUNTIF($A:$A,$A1)>1)

    condition 2
    =COUNTIF($A:$A,$A1)>1

    condition 3
    =$E1=12345

    Note: referring to just $E1 works because the formula automatically adjusts for each cell, in row 1 all 5 columns remain =$E1=12345 [ because the $ prevents any change] but in row 2 this will become $E2=12345

  2. #2
    Registered User
    Join Date
    08-22-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Conditional Format Entire Row Based On One Cell In Row

    Dear daddylonglegs, thank you for very helpful answers. Could you please add another example of using "Conditional Format Entire Row Based On One Cell In Row" when the criteria is that Cell contains a "string"

    Thanks a lot in advance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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