Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel |