1I am sorry but did not under stand this. Are you saying I can just type
example: =if a1<b2,"true" then under formatt change it to red? Or please give
an example.

I also have 2 more question. I keep getting deeper and deeper!!!! ha ha.

2Can I do like a role or cell by exmple: =if a1:a11<b2,"true" and turn it
red or how will this need to be done.

3Also can you reference to different worksheet using this conditional
format. I tried and got an error saying "You may not use references to other
worksheets or workbooks for Conditional Formatting criteria"

Thanks for all your help!!!

Mark Melancon

"Barb Reinhardt" wrote:

You could put the same formula in the cell and you'd get either TRUE or
FALSE.


--
HTH,
Barb Reinhardt



"Mark M" wrote:

That worked great but I have one more question. Can you put the word "true"
in the cell if =A1A2. It turned red like I asked it too but I also would
like to add words like "true" or "y" I tried =A1A2,"t" but this did not work.

Thanks again

"Barb Reinhardt" wrote:

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