Consulting

Results 1 to 2 of 2

Thread: Highlight cells which have no dependents

  1. #1

    Highlight cells which have no dependents

    have two sheets like sheet1 and sheet2. In sheet1 data is linked to sheet2 in C and D column. In other words data is going to sheet2 in C and D column from sheet1.

    I want macro colour cells in sheet1 which is not going to sheet2 in C and D column.

    For example:

    Sheet1
    A
    12
    89
    56
    78
    99
    33

    Sheet2
    A B C D
    0 0 0 12
    0 0 89 0
    0 0 0 78
    0 0 33 0

    Macro colour cell A3 and A6 because figure 56 and 99 not going to sheet2 in C and D column specifically.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,086
    Location
    Create a named range on sheet2 covering A, called say sheet2Data.

    Use conditional formatting on Sheet 1 with a formula of

    =NOT(SIGN(COUNTIF(sheet2Data,A1)))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •