Select the entire row or portion of the row to format.

FormatCFFormula is: =$D$1=123

Your cell ref and value may differ so edit the above to suit.

Main thing is to make the cell ref Absolute by inserting the $ signs as shown.


Gord Dibben MS Excel MVP

On Mon, 18 Dec 2006 11:29:00 -0800, Daviv
wrote:

I want to know how to format the entire row if a cell within the row meets a
certain condition. I could use condtional formatting to format only the cell
which meets that condition.