Hello all,
So i came up with a formula that i must use in conditional formatting, but i just can't make it work. What am i missing?
This is the normal formula that is working if used normally (not in conditional formatting):
=IF(AND(YEAR('Sheet2'!A16)=YEAR(TODAY()); SUMIFS(Table2[Delivery
plan];Table2[Date];"<="&'Sheet2'!$A$16)='Sheet2'!$D$16); "OK"; "NOTOK")
What this formula does, is this:
- if the year in cell A16 from Sheet2 is in this year
and
sum from column "Delivery plan" is identical with cell D16 from Sheet2,
THEN
fill cell with green
Any help please?
So i came up with a formula that i must use in conditional formatting, but i just can't make it work. What am i missing?
This is the normal formula that is working if used normally (not in conditional formatting):
=IF(AND(YEAR('Sheet2'!A16)=YEAR(TODAY()); SUMIFS(Table2[Delivery
plan];Table2[Date];"<="&'Sheet2'!$A$16)='Sheet2'!$D$16); "OK"; "NOTOK")
What this formula does, is this:
- if the year in cell A16 from Sheet2 is in this year
and
sum from column "Delivery plan" is identical with cell D16 from Sheet2,
THEN
fill cell with green
Any help please?