redruM
Breathe and Stop
- Joined
- May 11, 2004
- Messages
- 3,954
- Gender
- Male
- HSC
- 2003
Hey guys,
I've got a table in excel with numerical values.
What I want to do is to highlight (by having a coloured field, bolded, italicised or any other way) the cells which are greater than 100. I would preferably want those cells highlighted in the table itself...but I guess having them listed out wouldn't be too shabby.
The main point of the exercise is to get excel to find such cells, rather than to do it manually.
Is this even possible?
Thanks in advance.
edit: http://techonthenet.com/excel/questions/cond_format3.php should have just googled it in the first place.
I've got a table in excel with numerical values.
What I want to do is to highlight (by having a coloured field, bolded, italicised or any other way) the cells which are greater than 100. I would preferably want those cells highlighted in the table itself...but I guess having them listed out wouldn't be too shabby.
The main point of the exercise is to get excel to find such cells, rather than to do it manually.
Is this even possible?
Thanks in advance.
edit: http://techonthenet.com/excel/questions/cond_format3.php should have just googled it in the first place.
Last edited: