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:C100) then the background colour of B4 will be Green otherwise red.
Can anyone help me on this condition??
For example,
The value of B4=222333
If this value is existing in any cell of a range (C8:C100) then the background colour of B4 will be Green otherwise red.
Can anyone help me on this condition??
1 Reply
Sort By
You may use conditional formatting rule with the formula
=COUNTIF(C8:C100,B4)