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

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

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

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

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

"Mark M" wrote:

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.

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.

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.


I think this was answered in (1) above

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"

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)

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