Choose “Less Than," for instance, and the name becomes “Format Cells Less Than.”
#How do you create an if then formula in excel code#
Apply this rule to cells, and you can make Excel highlight words that contain text you specify without writing code to perform that task. Reading it as an IF-THEN statement can help you understand how to.