Conditional Formatting

  • Thread starter Thread starter jennie.chann
  • Start date Start date
J

jennie.chann

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.
 
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.
 
Back
Top