View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gunnar Boykin[_2_] Gunnar Boykin[_2_] is offline
external usenet poster
 
Posts: 2
Default Using conditional formatting in Excel 2007

This is probably a stupid question, but I am creating a database, in which I
want the cells in ex. range A2:G57 to highlight a certain color, but only if
the cell in the same row has a value of 1. Please understand that I don't
want all of the cells (A2:G57) to change, just the cells on the same row as
the cell that =1.

Any help is greatly appreciated. Please reply as if you're speaking to an
idiot who has never used Excel... Cause you are...

Thanks.