Try conditional formatting.

Select all target rows, starting in row 1
Menu FormatConditional Formatting

Change Condition 1 to Formula is
Add a formulae of =$C125000
Select Patterns tab and choose a colour
OK
Click Add
Change Condition 1 to Formula is
Add a formulae of =$C1<=25000
Select Patterns tab and choose another colour
OK
OK



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Don Doan" wrote in message
...
Hi,
how can I write a macro to do look for a value in a column, say column
"C",
if it's greater than or equal to 250,000 then highlight that row (in any
colour), if it's less than or equal to 250,000, then also hightlight that
row
(in any color). It will keep on finding value until the end of the row
(when
there is a blank line).

Thanks.