Forum Discussion

DamascusOne's avatar
DamascusOne
Copper Contributor
May 05, 2024

Looking to use table data to influence formatting of cells on separate tables.

I am looking to change the formula that my spreadsheet is using to colour certain cells using data that can be found in the table.   If you would like to the look at it as a file, there is a google...
excel
Formulas and Functions
DamascusOne's avatar
DamascusOne
Copper Contributor
May 11, 2024

mathetes I have updated the post to contain the file, which also has a more direct description/ directions of the goal i would like to attain.

 

Thanks

mathetes's avatar
mathetes
Gold Contributor
May 11, 2024
As Hans has written, you need to post a link that grants access. This one says we need to request access, so it's incomplete.
  • DamascusOne's avatar
    DamascusOne
    Copper Contributor
    May 12, 2024
    Permissions have been updated
    • mathetes's avatar
      mathetes
      Gold Contributor
      May 12, 2024

      DamascusOne 

       

      See if this is doing what you want. It's frankly not clear what you're doing and why. I took my lead from this portion of your original post.

      My current formula reads as followed:

      =AND(NOT(ISBLANK(A1)),INDEX(Sheet2!$E$2:$E$100,INT(ROW(A1)+1)/2)="brn")

       

      Which is very close to working however, I would like the formula to only colour A1 and A2, on Sheet 1( as seen below), brown instead of the entire row

       

      I will say that Conditional Formatting is often elusive, requiring a lot of trial and error. Since you were close to what you wanted to begin with, I'd encourage you to just keep playing. All I changed were the cells to which the conditional formatting was to be applied.

Resources