Using conditional formatting
 

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

Did that already. Didn't work. That why I'm here seeking more information.

"Pimamedic" wrote:

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

how do you have formula written in the conditional format

"Ayo" wrote:

Did that already. Didn't work. That why I'm here seeking more information.

"Pimamedic" wrote:

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

Formula:= "h6=i6"
Applies to =$I$6:$I$34

"Pimamedic" wrote:

how do you have formula written in the conditional format

"Ayo" wrote:

Did that already. Didn't work. That why I'm here seeking more information.

"Pimamedic" wrote:

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

try removing the quotes

"Ayo" wrote:

Formula:= "h6=i6"
Applies to =$I$6:$I$34

"Pimamedic" wrote:

how do you have formula written in the conditional format

"Ayo" wrote:

Did that already. Didn't work. That why I'm here seeking more information.

"Pimamedic" wrote:

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

forgot put = in front of h6

should be =h6=i6

"Ayo" wrote:

Formula:= "h6=i6"
Applies to =$I$6:$I$34

"Pimamedic" wrote:

how do you have formula written in the conditional format

"Ayo" wrote:

Did that already. Didn't work. That why I'm here seeking more information.

"Pimamedic" wrote:

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

Thanks so much. It worked.

"Pimamedic" wrote:

forgot put = in front of h6

should be =h6=i6

"Ayo" wrote:

Formula:= "h6=i6"
Applies to =$I$6:$I$34

"Pimamedic" wrote:

how do you have formula written in the conditional format

"Ayo" wrote:

Did that already. Didn't work. That why I'm here seeking more information.

"Pimamedic" wrote:

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.

Using conditional formatting
 

YQW

"Ayo" wrote:

Thanks so much. It worked.

"Pimamedic" wrote:

forgot put = in front of h6

should be =h6=i6

"Ayo" wrote:

Formula:= "h6=i6"
Applies to =$I$6:$I$34

"Pimamedic" wrote:

how do you have formula written in the conditional format

"Ayo" wrote:

Did that already. Didn't work. That why I'm here seeking more information.

"Pimamedic" wrote:

Select cell you want to format
Select format conditional format
Change to formula is
=h6=i6
click format
click pattern
select color you want
use format painter to copy to remaining cells

"Ayo" wrote:

I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I want to do this for I6:I34.
How do I go about doing this?
Thanks.