I have 2~3 tables that share the same titles and different values. I want to change the color of font based on the value of another cell...it's confusing so I will explain with an example.
Table1
ColumnA(Title) ColumnB(Group1) ColumnC(Group2)
ABC 80 90
BCD 60 30
CDE 50 40
DEF 30 30
.
.
.
Table2
ColumnA(Title) ColumnB(Group1) ColumnC(Group2)
DEF 70 100
ABC 10 30
CDE 90 50
BCD 70 80
So what I want to do is IF ColumnB and ColumnC in Table 1 is less than 45, I want corresponsing numbers in Table 2 to be red. ColumnA in Table1 and Table2 has to match. The order of ColumnA in Table1 and the order of ColumnA in Table2 are different. I can't change this order to match them. It has to be the way it is. I can probably use IF, but I don't know what to do from there....
I have this formula "=IF(VLOOKUP($A67,Table1,1+1,0)<45,1,0)". I defined the first table as Table1 and the second table as Table2. Table1 starts at A13 and end at AN45. Table2 starts at A67 and end at AN99. Both Table1 and Table2 are filled with number(no empty cell). Column A consists of titles for table 1 and table2 (My table is placed top and bottom instead of side to side). I am not sure if column index is incorrect or something else is incorrect. I just set a cursor on an empty cell and entered this formula and clicked apply. All I get is #N?A.....WHY. If you could describe what you did on your spreadsheet I would aapreciate it. I suppose I need to use conditional formatting to change font color, but ....nothing worked....Anybody has an idea of how to fix it??
.
.
.
Bookmarks