Change text colour according to number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R.Demandt - 27 Nov 2006 18:55 GMT

Does anyone now how I can let the text colour change according to the number
in the cell? If the number = 6 or above the text needs to be geen, If the
number = 5,9 or lower the text needs to be red.

Thanks for any help,
R.Demandt

Reply to this Message

Ron Coderre - 27 Nov 2006 19:04 GMT

Try this:

Select the cell(s) to be impacted

From the Excel main menu:
<format><conditional formatting>
For Condition_1
Cell Value is: Greater than or equal to: 6
Click the [format] button and set your format
Click the [OK] button

For Condition_2
Cell Value is: Less than: 6
Click the [format] button and set your format
Click the [OK] buttons to finish

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> Does anyone now how I can let the text colour change according to the number
> in the cell? If the number = 6 or above the text needs to be geen, If the
> number = 5,9 or lower the text needs to be red.
>
> Thanks for any help,
> R.Demandt

Reply to this Message

R.Demandt - 28 Nov 2006 08:24 GMT

It worked, thanks for your help!

> Try this:
>
[quoted text clipped - 25 lines]
> > Thanks for any help,
> > R.Demandt

Reply to this Message