Forum Discussion

null null's avatar
null null
Copper Contributor
Oct 03, 2018

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??

Resources