VBA (I Think!)

Anonymizeruk · Mar 12th, 2002, 04:07 AM

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

dk · Mar 12th, 2002, 04:18 AM

No VBA needed. Click the cell you want to apply the formatting to and choose Conditional Formatting. Then you'd use something like:-

Condition 1
Cell Value Is Equal to TRUE (choose a format of red)

Condition 2
Cell Value Is Equal to FALSE (choose a format of black)

HTH,
Dan

Anonymizeruk · Mar 12th, 2002, 12:51 PM

Nice and simple (Just the way I like it!)

Thanks a lot - I really appreciate your help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 04:07 AM	#1
Anonymizeruk New Member Join Date: Mar 2002 Location: Nottingham, England Posts: 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

Mar 12th, 2002, 04:18 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	No VBA needed. Click the cell you want to apply the formatting to and choose Conditional Formatting. Then you'd use something like:- Condition 1 Cell Value Is Equal to TRUE (choose a format of red) Condition 2 Cell Value Is Equal to FALSE (choose a format of black) HTH, Dan

Mar 12th, 2002, 12:51 PM	#3
Anonymizeruk New Member Join Date: Mar 2002 Location: Nottingham, England Posts: 2	Nice and simple (Just the way I like it!) Thanks a lot - I really appreciate your help.