Hello,
I do not know if what I am trying to accomplish is possible with this formula. I have the entire formula working in a normal cell to return a TRUE/FALSE based on criteria. I cannot figure out how to translate this formula into the conditional formatting.
In the attached document:
ExecView!F8:F16 needs the conditional formatting
ExecView!J8 contains contains the example of the formula I want to use for the conditional formatting
{=IF(F8<(INDEX(tbl_Thresholds[Reserve(T3)],MATCH(A8&H8,tbl_Thresholds[SITE]&tbl_Thresholds[Man.],0))*0.5),TRUE,FALSE)}
ExecView!K8 contains only the portion of the above formula that is the variable to ensure the INDEX(MATCH) is functioning
{=INDEX(tbl_Thresholds[Reserve(T3)],MATCH(A8&H8,tbl_Thresholds[SITE]&tbl_Thresholds[Man.],0))}
Hopefully someone can assist on how to accomplish this, maybe with a different formula to get the same results.
Thanks
B
Bookmarks