Forum Discussion
Excel conditional formating
In Microsoft Excel 2003/XP/2000/97, I'm trying 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 cell B4=222333
If this value matches with any cell of a range (C8:C100) then B4 (backgroun) will be Green otherwise red.
Can you help about this?
For example,
The value of cell B4=222333
If this value matches with any cell of a range (C8:C100) then B4 (backgroun) will be Green otherwise red.
Can you help about this?
1 Reply
pls see attached file
hope this could be of help
thanks..
