Using IF function to change font color

[powerwindow]

Hey all,
I'm trying to use Excel to keep team standings for a baseball board game. I had no problem calculating wining percentage. Finally figured out how to calculate 'games behind.' Now I'm wondering if there is a way to change the font color of a team name based on their wining pct?

A typical row contains: A2(Team Name), B2 (Wins), C2 (Losses), D2 (Pct (B2/(B2+C2)), E2 (GB)

Is there a way to use the IF function to return the 'Team Name' in green if D2>.500, 'Team Name' in red if D2<.500, and 'Team Name' in black if D2=.500 ??

Thanks for any help.
Sips

[martindwilson]

conditional format a2

format/conditional formating
choose formula is from dropdown
formula is
=d2>0.5 pick green font from formats
=d2<0.5 pick red font
no need to do =0.5 as it will just stay black any way

[JBeaucaire]

Yes, this is called CONDITIONAL FORMATTING.

• Highlight the entire column Team Names starting with A2 as the first cell so it's still primary.
• Click on Format > Conditional Formatting
• Use these parameters:
  
  Condition1: Formula Is: =D2>.5
  Format: FONT (or pattern for background color changes): select a green
  
  Add>
  
  Condition2: Formula Is: =D2<.5
  Format: Font: select a red

Now format the column in BLACK font for the ones the equal .5. The others will change themselves to red and green based on the values in column D.

[powerwindow]

Awesome! Thanks very much. Super easy.
Sips

[JBeaucaire]

Glad we could help...if that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].



(Also, use the "scales" icon in our posts to leave Feedback, it is appreciated)