Select A1:Q1, then go to Format, Conditional Formatting... and selecting the
drop down menu, chose "Formula Is". Then input "=countA($A1)=1 and then
chose your formatting, i.e. bold font, pattern, etc. Once you have done
that, drap A1:Q1 down as far as you want the range to be affected.

Hope that helps,

leimst

"bookmanu3" wrote in message
...
The cells in Column A are currently blank. How do I highlight the data in
A1:Q1 if I type a number in A1? I will need to be able to copy this to all
the rows in the worksheet so that as I assign numbers to the rows the
entire
row will be highlighted. Thanks!