Results 1 to 4 of 4

Coloring two rows: IF: comparing duplicates in two columns with a third boolean column

Threaded View

Matan93 Coloring two rows: IF:... 04-05-2023, 11:20 PM
samba_ravi Re: Coloring two rows: IF:... 04-06-2023, 03:00 AM
Matan93 Re: Coloring two rows: IF:... 04-06-2023, 04:00 AM
Matan93 Re: Coloring two rows: IF:... 04-06-2023, 04:01 AM
  1. #1
    Registered User
    Join Date
    04-05-2023
    Location
    Norway
    MS-Off Ver
    2023
    Posts
    3

    Angry Coloring two rows: IF: comparing duplicates in two columns with a third boolean column

    Hi,

    Quite new to Excel to this extent. I'm trying to build up an inventory list, and as a result, a sheet for borrowing equipment.

    I need to compare duplicates in A and B to a boolean in E, if it's not returned and I try to add in someone borrowing equipment, I need equipment and ID-number to turn red.
    So when Rachel is trying to borrow the multimeter in A12, the moment the formula reads duplicate in A and B, and False in E, A12 and B12 will turn red
    Also when Martin try to borrow the drill again in A13, it will turn red because of the same reason

    I'm trying =IF((AND(A2:A15, >1),(AND(B2:B15, >1))(AND(E2:E15, "No")))
    (BTW, I see that I forgot to add the B-column in the example, nvm that)
    But to no avail. I've spent 10 hours on searching just on blind stubbornness. Have I ventured too far out in newbie-land?

    Please help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 03-06-2021, 04:49 PM
  2. [SOLVED] Comparing two columns for duplicates
    By mattdykes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2021, 01:14 PM
  3. [SOLVED] columns with duplicates to one column and rows help?
    By amelie19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2018, 11:23 AM
  4. [SOLVED] Remove rows based on duplicates in certain columns, and merge data from another column
    By yanagi600 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-02-2013, 04:17 PM
  5. [SOLVED] Comparing 2 columns and deleting duplicates in the second column according first column
    By wingo033 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-19-2012, 07:14 PM
  6. Comparing two columns for duplicates
    By michaelrusk in forum Excel General
    Replies: 1
    Last Post: 07-16-2012, 09:18 AM
  7. Comparing Two columns to create column with duplicates
    By braves1t in forum Excel General
    Replies: 6
    Last Post: 04-29-2010, 08:31 AM

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