can font color be controled in an IF statement
 

I'm doing a simple % calculation. If the returned % is greater than 100%, I
want the % to be displayed in red so it's noticable. Otherwise I just want
the % displayed in black font. Can this be done?

can font color be controled in an IF statement
 

Hi,

You can do that with conditional formatting. Set a conditional format of
cell value is 1 and select a colour, format the cell as percentage

Mike

"Confused Rookie" wrote:

I'm doing a simple % calculation. If the returned % is greater than 100%, I
want the % to be displayed in red so it's noticable. Otherwise I just want
the % displayed in black font. Can this be done?

can font color be controled in an IF statement
 

Excellent, worked great and was easy, thanks-

"Mike H" wrote:

Hi,

You can do that with conditional formatting. Set a conditional format of
cell value is 1 and select a colour, format the cell as percentage

Mike

"Confused Rookie" wrote:

I'm doing a simple % calculation. If the returned % is greater than 100%, I
want the % to be displayed in red so it's noticable. Otherwise I just want
the % displayed in black font. Can this be done?

can font color be controled in an IF statement
 

FormatConditional Formatting can be used in this case.


Gord Dibben MS Excel MVP

On Wed, 21 Nov 2007 07:05:03 -0800, Confused Rookie
wrote:

I'm doing a simple % calculation. If the returned % is greater than 100%, I
want the % to be displayed in red so it's noticable. Otherwise I just want
the % displayed in black font. Can this be done?