How to create conditional formatting for constantsĬlick the format button and choose the formatting you would like for your constants (blue font color for example). Select some cells (preferably with both formulas and constants in) to apply your conditional formatting to create a new conditional formatting rule, choose the ‘use a formula…’ option. Type the following formula in the ‘rule description': =cellhasnoformula How to create a new conditional formatting rule In the ‘Refers to:’ box type the following: =NOT(GET.CELL(48,INDIRECT(“rc”,FALSE)))
Did you think that conditional formatting for constants (blue font color for example) was impossible? Well think again!Ĭreate a new named range called cell has no formula.
