Previous Topic Next Topic

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

Answer 1 / 3
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?
0
CBSC
Aug 19, 2009 at 08:22 AM
Office XP
0
Answer 2 / 3
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.
0
Answer 3 / 3
vaan
May 21, 2010 at 06:19 AM
is this a c/c++ problem?
0