View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default 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.