Thread: Coloring a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
marcus[_3_] marcus[_3_] is offline
external usenet poster
 
Posts: 140
Default Coloring a row

Hi John

This sort of thing will work in 2003 conditional formating. In Cell
A3 go to Format - conditional formattting. Formula is

Paste this

=IF($H3<"",1,)

Choose your interior colour design.

Now copy this across to K3 and down to where you require it. You will
see that when there is data in Colmn H the corresponding row now turns
into the colour you specified.

This worked fine for me and I am using 2003.

Take care

Marcus