Conditional Format
 

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.

Conditional Format
 

I'm afraid XL alone can not detect a formula, only values

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Coach" wrote:

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.