Change text colour according to number

[Guest]

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

 

[Guest]

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

 

[Guest]

It worked, thanks for your help!

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