Try this:

1. Select the rows to be formatted
2. Choose FormatConditional Formatting...
3. From the first drop-down list, choose Formula Is
4. In the text box, enter a formula that refers to the active cell i
the selection.

For example: =$B275

Use an absolute reference to column B ($B), to ensure that th
conditional formatting in all columns refers to the value in column B
Otherwise, the formula will be adjusted in each column, and won't wor
properly.

:cool

--
chriskxp212
-----------------------------------------------------------------------
chriskxp2123's Profile: http://www.excelforum.com/member.php...fo&userid=2583
View this thread: http://www.excelforum.com/showthread.php?threadid=39477