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