Color text change

Closed
CBSC - Aug 3, 2009 at 03:14 PM
 vaan - May 21, 2010 at 06:19 AM
Hello,

I want to know how to set an IF Statement that would change the color of the number in a particular cell based on a greater or less then scenario?


Thanks

3 responses

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Aug 18, 2009 at 03:53 PM
which version of excel are you using?
Office XP
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Aug 19, 2009 at 02:25 PM
What you want to achieve is done with 'Conditional Formatting'

If you hit F1 and do a search on conditional formatting it will explain what you need to do to achieve your aim.
is this a c/c++ problem?