I like to test my rules in the worksheet first.
And any formulas that evaluate to zero will not have the formatting applied. *A little known fact is formulas that evaluate to any positive or negative number will also be considered as 'TRUE' and the format will be applied. If the outcome is true or 1 it will apply the format, if it’s false or 0 it won’t. Excel for Customer Service ProfessionalsĬonditional Formatting with Formulas - Written Instructions Rule 1 – the formula must evaluate to TRUE or FALSE*Ĭonditional formatting is looking for a true or false outcome, or their numeric equivalents 1 and 0.
0 kommentar(er)
