View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default highlighting rows according to a input value?

Yes you can highlight an entire row.

Select the row(s) and FormatCF Formula is:

=$A1=10

Note the $ sign which locks the column A


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 13:48:45 -0600, MC82
wrote:


can we use conditional formatting to hightlight a whole row? I thought
it only hightlights the specific cell