Hi -
I have a table of data (Table A) that I am trying to highlight if the formulas into a corresponding table (Table B) are equal to 0 or 1. So when Table B = 1, the corresponding cell in Table A would turn to red.
I have been trying all day to write the correct formula that would allow me to reference the formula in Table B, to allow for the conditional formatting in Table A. The problem is, when I go to copy the formula to all the other cells in Table A, it references the cell where I first wrote the original formula.
Can someone please help me understand how to write the correct formula for this conditional formatting? I posted my spreadsheet to show what I am viewing. Please help!!Book2.xlsx
Bookmarks