Forum Discussion

DeeDeeFP's avatar
DeeDeeFP
Copper Contributor
May 12, 2022

Formula and Functions

this is just an example below of what i'm looking for.  I would like to be able to highlight every other circuit along with the rows associated with it.  I tried conditional formatting but i don't kn...
Formulas and Functions
  • DeeDeeFP's avatar
    DeeDeeFP
    Copper Contributor
    May 12, 2022
    i'm looking for a formula to highlight all the rows associated with the same circuit #, then not highlight the next group,, then highlight the next. Everyother group of rows associated with the same circuit. Not sure if that's possible?
    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      May 12, 2022

      DeeDeeFP 

      Maybe like in the attached file. The values from column E are copied in column H. Then duplicates are removed with Data -> Remove Duplicates.

       

      Every other # is then selected in column I with this formula:

      =IF(MOD(ROW(),2)=1,H1,"")

       

      This is the rule for conditional formatting which compares the values in column E with the values in column I:

      =ISNUMBER(MATCH($E1,$I$1:$I$6,0))

       

Resources