View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nelson Nelson is offline
external usenet poster
 
Posts: 69
Default If cel in next colum same row = less color red

Good day, I am not sure if conditional formatting will work with this but
here is what I am looking for

I have 2 columns H and I. H has previous years sales numbers and I has
current years.

I want to select all of column I and say if cell in H (same row) is less
than I turn I column red

Any suggestions

Thanks
--
Nelson