If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|