View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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.