Anonymizeruk
New Member
- Joined
- Mar 11, 2002
- Messages
- 2
Greetings folks. My first time here.....
Now, I'm sure this question has been asked many times, but here we go again....
I've been putting together some Excel sheets at work for gathering and processing various statistics (HEAVY use of the IF / COUNTIF functions!).
I was wondering if there is a way to pick which colour is used depending on certain results.... eg
A3 - =IF(A1>A2"YES",))
Obviously, if A1=2 and A2=1, then A3=YES (sounds like BBC Basic to me!).
What I would like to do is also use the result to determine the text colour, so that a 'TRUE' result would appear red, and a 'FALSE' result would appear black, and so on....
Oh - if it makes any difference, I will be using Excel 97.
Any help would be appreciated.
Thanks
Now, I'm sure this question has been asked many times, but here we go again....
I've been putting together some Excel sheets at work for gathering and processing various statistics (HEAVY use of the IF / COUNTIF functions!).
I was wondering if there is a way to pick which colour is used depending on certain results.... eg
A3 - =IF(A1>A2"YES",))
Obviously, if A1=2 and A2=1, then A3=YES (sounds like BBC Basic to me!).
What I would like to do is also use the result to determine the text colour, so that a 'TRUE' result would appear red, and a 'FALSE' result would appear black, and so on....
Oh - if it makes any difference, I will be using Excel 97.
Any help would be appreciated.
Thanks