IF statements and font colour

acura · Apr 24th, 2002, 01:04 PM

this may seem like an odd question. Im trying to set up an IF statement using 2 sheets. Im am basically saying IF (cell A) is greater than (Cell B), then print (cell A) in a new cell, AND USE GREEN FONT.
I can setup the IF statement no problem, but I dont know if there is a way to include putting the info in green font if it satisfies the IF statement. Any help would be much appreciated.
thanks

Mark W. · Apr 24th, 2002, 01:08 PM

See the Excel Help Index topic for "Apply conditional formats to cells".

acura · Apr 24th, 2002, 01:14 PM

Ive looked through there, and I cant find anything that gives me a syntax for font attributes.

acura · Apr 24th, 2002, 01:23 PM

AHH...nevermind..found it...
thanks!

acura · Apr 24th, 2002, 01:43 PM

duh..further to the above question.
I have it setup like this:

a1 a2
if a2>a1...then print a2 in green font.

figured that out.

Now I cant figure out how to copy this conditional formula downwards through b1 b2, c1 c2 etc...it keeps copying the formula making reference to cell a1...Ive tried highlighting the whole range of cells to be formatted with the same conditions, but it will not allow me to do so....

help!
thx.

Mark W. · Apr 24th, 2002, 01:49 PM

Quote:

On 2002-04-24 12:43, acura wrote:
duh..further to the above question.
I have it setup like this:

a1 a2
if a2>a1...then print a2 in green font.

figured that out.

Now I cant figure out how to copy this conditional formula downwards through b1 b2, c1 c2 etc...it keeps copying the formula making reference to cell a1...Ive tried highlighting the whole range of cells to be formatted with the same conditions, but it will not allow me to do so....

help!
thx.

So you've applied a conditional format to cell A2? Copy A2 and Paste Special... Formats onto cell B2, C2, etc.

...Or, with cell A2 selected double-click the Format Painter toolbar button and the drag across B2, C2, etc.

Brian from Maui · Apr 24th, 2002, 01:51 PM

Acura,

If you're trying to anchor A1 use $A$1

If you want to copy and paste using B1,C1, etc. click on the cell, copy, go to Edit/Paste Special/Format

acura · Apr 24th, 2002, 01:55 PM

Ive tried both those methods..The problem that I seem to be getting, is even when I "paste special" the formats, to cells b2, c2 etc...it is still basing the conditional formula on the original cell A1.

ie: if a2 > a1 print a2 in green font.
when i paste special the format down to cell b2, it is still comparing b2 to a1...and not b1...I dont know why...ive tried paste special and format painter, with the same results.

acura · Apr 24th, 2002, 02:00 PM

ok..im a moron.

ive figured it out....when I used that conditional format wizard thing, and clicked to select the cell to base my conditions on...it automatically defaulted to $a$1...
duh.

Aladin Akyurek · Apr 24th, 2002, 02:03 PM

Quote:

On 2002-04-24 12:55, acura wrote:
Ive tried both those methods..The problem that I seem to be getting, is even when I "paste special" the formats, to cells b2, c2 etc...it is still basing the conditional formula on the original cell A1.

ie: if a2 > a1 print a2 in green font.
when i paste special the format down to cell b2, it is still comparing b2 to a1...and not b1...I dont know why...ive tried paste special and format painter, with the same results.

An easier method is to select the whole range of interest starting at A1 and use your formula:

=A2>A1

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

Apr 24th, 2002, 01:04 PM	#1
acura New Member Join Date: Apr 2002 Posts: 6	this may seem like an odd question. Im trying to set up an IF statement using 2 sheets. Im am basically saying IF (cell A) is greater than (Cell B), then print (cell A) in a new cell, AND USE GREEN FONT. I can setup the IF statement no problem, but I dont know if there is a way to include putting the info in green font if it satisfies the IF statement. Any help would be much appreciated. thanks

Apr 24th, 2002, 01:08 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help Index topic for "Apply conditional formats to cells".

Apr 24th, 2002, 01:14 PM	#3
acura New Member Join Date: Apr 2002 Posts: 6	Ive looked through there, and I cant find anything that gives me a syntax for font attributes.

Apr 24th, 2002, 01:23 PM	#4
acura New Member Join Date: Apr 2002 Posts: 6	AHH...nevermind..found it... thanks!

Apr 24th, 2002, 01:43 PM	#5
acura New Member Join Date: Apr 2002 Posts: 6	duh..further to the above question. I have it setup like this: a1 a2 if a2>a1...then print a2 in green font. figured that out. Now I cant figure out how to copy this conditional formula downwards through b1 b2, c1 c2 etc...it keeps copying the formula making reference to cell a1...Ive tried highlighting the whole range of cells to be formatted with the same conditions, but it will not allow me to do so.... help! thx.

Apr 24th, 2002, 01:51 PM	#7
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Acura, If you're trying to anchor A1 use $A$1 If you want to copy and paste using B1,C1, etc. click on the cell, copy, go to Edit/Paste Special/Format

Apr 24th, 2002, 01:55 PM	#8
acura New Member Join Date: Apr 2002 Posts: 6	Ive tried both those methods..The problem that I seem to be getting, is even when I "paste special" the formats, to cells b2, c2 etc...it is still basing the conditional formula on the original cell A1. ie: if a2 > a1 print a2 in green font. when i paste special the format down to cell b2, it is still comparing b2 to a1...and not b1...I dont know why...ive tried paste special and format painter, with the same results.

Apr 24th, 2002, 02:00 PM	#9
acura New Member Join Date: Apr 2002 Posts: 6	ok..im a moron. ive figured it out....when I used that conditional format wizard thing, and clicked to select the cell to base my conditions on...it automatically defaulted to $a$1... duh.