Check out Help on Conditional Formatting.

If you need more help, post back with some specifics like

Is the single cell in each row in the same column?

How much of each row do you want colored?

Entire row or just maybe columns A to M?


Gord Dibben MS Excel MVP

On Sun, 5 Jun 2011 05:48:13 -0700 (PDT), Skip wrote:

of a row of values, depending upon the value of a single cell.
I have 400 rows of data. I would like to change the row color,
if the value of a cell in each row is for example less than 3.
Is there a way to do this using a formula?
I appreciate any help.
Skip