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 |
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 |
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 |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com