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 the cells containing the string Physics to be green. Is this possible?
1 Reply
- OliverScheurichGold Contributor
=ISNUMBER(SEARCH("Math",A1))
=ISNUMBER(SEARCH("Physics",A1))
I entered the above rules for conditional formatting and the cells are highlighted.