Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change text colour according to number
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change text colour according to number
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 "R.Demandt" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change text colour according to number
It worked, thanks for your help!
"Ron Coderre" wrote: 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 "R.Demandt" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change fromat from number to text | Excel Discussion (Misc queries) | |||
how i change thai text to english text | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
How do i change numbers in text format to number format? | New Users to Excel |