Try this
=A1A2

--
HTH,
Barb Reinhardt



"Mark M" wrote:

Hey everyone!!
My question is: I am using Conditional Format to change the color of a cell
when two other cell are different. For example : I type in under condition 1
"formula is" =if(a1a2,"true") and under format change the cell red. When I
do this nothing happens but if I type this in a if statement then it works
but I don't have the option to color the cell.

My question is how do I do a if statement or what is wrong with my above
statement in conditional format.

Also can you do multi statement in one format.

Thanks

Mark Melancon