Thread: Coloring a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John K John K is offline
external usenet poster
 
Posts: 24
Default Coloring a row

I have a spreadsheet and I want to have cells colored from column A to K if
cell h is not blank. So if h3 has a date in it I want A3:K3 to be say light
blue. This is for Office 2003. I can do it with conditional formating in
2007, but my work place doesn't have 2007. I did use column L and put an if
statement to give a true or false in the cell depending on if the cell in
col. h was empty or not. Any ideas how to get this to work?