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.
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, and then do that with all of the couple cells in Sheet 1 so that the spreadsheet reads column E on Sheet 2 (seen below) and changes the colour of the cells based on the colour on the same row as the data.
Thank you in advance.
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. 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, and then do that with all of the couple cells in Sheet 1 so that the spreadsheet reads column E on Sheet 2 (seen below) and changes the colour of the cells based on the colour on the same row as the data.Thank you in advance. Read More