Conditional Formatting

Can someone help please!

I would like to format cell colors based on values that are in the cell. The
numbers in the cells are alpha-numeric order numbers followed by a number of
days in the sytem (e.g. x12345678-14). Some cells have up to 14 "orders" in
it.

How can I conditionally format the cell if the number of days is between
7-14 (green), 15-24 (Yellow) or >25 (red). I am using Office 2007.

Thanks in advance!
-Rob

dessa
Thu May 08 10:07:01 CDT 2008

try this http://www.contextures.com/xlfaqFun.html#CondFormat

"Rob Walter" wrote:

> Can someone help please!
>
> I would like to format cell colors based on values that are in the cell. The
> numbers in the cells are alpha-numeric order numbers followed by a number of
> days in the sytem (e.g. x12345678-14). Some cells have up to 14 "orders" in
> it.
>
> How can I conditionally format the cell if the number of days is between
> 7-14 (green), 15-24 (Yellow) or >25 (red). I am using Office 2007.
>
> Thanks in advance!
> -Rob