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
|