How to judge a cell that meets certain conditions and automatically identify the color in another cell in Excel?

Select cell A 1, create a rule with a formula in conditional format, and then enter.

= isnumber (find ("time", B 1)) format, select the fill color yellow, and then confirm.

Method 2:

Select cell A 1, create a rule with a formula in conditional format, and then enter.

= COUNT（FIND（“time“，b 1））& gt； 0 ? Format selection fill color yellow, OK.