View Single Post
  #1  
Old March 10th, 2010, 04:30 PM posted to microsoft.public.excel.newusers
mns
external usenet poster
 
Posts: 26
Default fill a color to a row

Hi,
I want to check a column (lets say H) if there is a 1 value i want excel to
color the row.

lets say there is a 1 on H6, I want to fill a color to row 6. It can be full
coloring or if i can i might like to range it to A6:J6

thanx in advance
Ads