Forum Discussion
Solved
Excel: inconsistent result when using conditional formatting
This use of conditional formatting statement does not work consistently: IF(((Saskatchewan!$C15+$C15)<>0),1,0) (Format specifies a colour) for a range = $C$15:$C$379 The statement fills the ce...
- Good Idea; very succinct expression. I believe that I've solve the inconsistencies by re-arranging the order of the conditional statements.
Good Idea; very succinct expression. I believe that I've solve the inconsistencies by re-arranging the order of the conditional statements.
SAngley wrote: ``I believe that I've solve the inconsistencies by re-arranging the order of the conditional statements``
Perhaps not. Refer to my response at Conditional Formatting works inconsistently .