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

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!

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

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.

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

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!