You are right, use conditional formatting. If you have Excel 2007 then it is
a breeze.

Choose Conditional Formatting-Highlight Cell Rules-Between
Enter your values and choose the formatting you want.

Let me know if you run into problems.

"jennie.chann" wrote:

I have a task to color certain cells that fall within a certain value. The
problem is I can't seem to figure out how to assign absolute values.. Can
someone tell me how ?
Maybe if not conditional formatting..VB?
Thanks.