Thread: can font color be controled in an IF statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote