Forum Discussion
EmilStromberg
Nov 12, 2021Copper Contributor
Formating cells with string of text?
Hi! I wonder if it is possible to create a rule for formatting cells from just a string of the text in the cell. As in my file I would like all the cells containing the string Math to be blue and...
OliverScheurich
Nov 12, 2021Gold Contributor
=ISNUMBER(SEARCH("Math",A1))
=ISNUMBER(SEARCH("Physics",A1))
I entered the above rules for conditional formatting and the cells are highlighted.