![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |