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