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!
|