Thread: Coloring a row
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Coloring a row

hi
you can do it with conditional formating in 2003.
High light the range A3:K3
on the 2003 menu barformatconditional formating.....
in the CF dialog enter....
Formula is.......=$H3<""....... click the format button and pick your color
from patterns.
you can copy the range A3:K3 down as far as you want/need.

Regards
FSt1

"John K" wrote:

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?