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