"Roger Govier" wrote:

Hi Mike

Works just fine for me with XL2007, either by doing a single column and
using format painter, or selecting all columns first and Home
tabConditional FormattingNew ruleUse formula =A1<A$524


--
Regards

Roger Govier


Thanks, Roger, for taking a stab at this.

I can follow your example and get it to work OK, but what formula would you
use if the top three rows of the table have titles in them and you don't want
to apply the conditional format to them?

Mike