Forum Discussion
null null
Oct 03, 2018Copper Contributor
Conditional formating
I want to change background color of a cell when its value matches to others any cell's value in a range. For example, The value of B4=222333 If this value is existing in any cell of a range (C8:...
SergeiBaklan
Oct 03, 2018Diamond Contributor
You may use conditional formatting rule with the formula
=COUNTIF(C8:C100,B4)