Conditional Format

[Guest]

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(a1>a2,"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

 

[Guest]

Try this
=A1>A2

 

[Guest]

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

Thanks again

 

[Guest]

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

 

[Guest]

1>I 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.

2>Can 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.

3>Also 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

 

[Guest]

1>I 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.

In the cell, you can put
=IF(a1<B2,"TRUE","FALSE")

In the conditional format, you can check for either TRUE or FALSE and format
as needed.

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

2>Can 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.

I think this was answered in (1) above

3>Also 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"

You can reference other worksheets if you use a named range. Let's say you
define a named range of TEST as Sheet2!A1. You can then check to see if the
cell is equal to TEST in the conditional format (using the formula option)