How to format range of cells using Conditional Formatting-Excel?

[bookmanu3]

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!

 

[Dave]

Hi,
Select Columns A:Q
In conditional format, select Formula is'
Enter =NOT(ISBLANK($A1))
Set desired format.
OK.
Any entry in Column A will format its row. To restrict this to a date you
could use data validation.
Regards - Dave.

 

[leimst]

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