Using conditional formatting

[Ayo]

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.

 

[Pimamedic]

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]

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

 

[Pimamedic]

how do you have formula written in the conditional format

 

[Ayo]

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

how do you have formula written in the conditional format

 

[Pimamedic]

try removing the quotes

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

 

[Pimamedic]

forgot put = in front of h6

should be =h6=i6

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

 

[Ayo]

Thanks so much. It worked.

forgot put = in front of h6

should be =h6=i6

 

[Pimamedic]

YQW

Thanks so much. It worked.