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
|