C
Coach
I'm overthinking this:
I need to conditionally format a cell(s) within a range of cells only if the
nested formula contains an additional operator.
Cells in Column D are multiplied by the cells in Column E as a base, and
displayed in Column F. Example F=(D3*E3)
Row 26 contains my FX Rate Multiplier.
What I am trying to do is to have the cells within the format range to be
highlighted if the nested formula DOES NOT equal the base formula. Example
F=(D3*E3)*B26
Basically, IF F=(D3*E3), then no highlight; If F=(D3*E3)*B26, then highlight.
I've tried IF, AND, NOT, OR and everything else I can think of. The only
thing I have accomplished is to highlight the entire range instead of those
that contain the FX multiplier.
I need to conditionally format a cell(s) within a range of cells only if the
nested formula contains an additional operator.
Cells in Column D are multiplied by the cells in Column E as a base, and
displayed in Column F. Example F=(D3*E3)
Row 26 contains my FX Rate Multiplier.
What I am trying to do is to have the cells within the format range to be
highlighted if the nested formula DOES NOT equal the base formula. Example
F=(D3*E3)*B26
Basically, IF F=(D3*E3), then no highlight; If F=(D3*E3)*B26, then highlight.
I've tried IF, AND, NOT, OR and everything else I can think of. The only
thing I have accomplished is to highlight the entire range instead of those
that contain the FX multiplier.