| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change colour of Text if number in cell exceed limit
Is it possible to set a limit to the number in the cell to switch its colour? Example: seting cell A1 to change it's text to "red" after exceeds 100. -- Lewis Koh ------------------------------------------------------------------------ Lewis Koh's Profile: http://www.excelforum.com/member.php...o&userid=25712 View this thread: http://www.excelforum.com/showthread...hreadid=392015 |
|
#2
|
|||
|
|||
|
see conditional formatting (format....conditional formatting) -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=392015 |
|
#3
|
|||
|
|||
|
From the menus:
Format Conditional Formatting Cell Value Is greater than 100. Set required fomat. Regards Rowan "Lewis Koh" wrote: Is it possible to set a limit to the number in the cell to switch its colour? Example: seting cell A1 to change it's text to "red" after exceeds 100. -- Lewis Koh ------------------------------------------------------------------------ Lewis Koh's Profile: http://www.excelforum.com/member.php...o&userid=25712 View this thread: http://www.excelforum.com/showthread...hreadid=392015 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| text color change in cell reference | Excel Discussion (Misc queries) | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
| how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
Linear Mode
