如何通过IF条件设置字体（非单元格）颜色？含多单元格对比规则需求

Let's break this down clearly depending on whether you're using Google Sheets (since you mentioned the STYLE function) or Excel:

Google Sheets Solution (Using STYLE for Font Color) #

You were right that STYLE handles background color, but it also supports font color styling with simple CSS-like syntax. Here's how to apply your exact rules without text replacement:

For Cell A2 #

Wrap your existing calculation formula inside the STYLE function, using an IF statement to toggle font color based on the 5% threshold:

=STYLE(IF(A2<0.05, "font-color: #C00000", "font-color: #00B050"), A2)

• #C00000 matches the Red 3 color
• #00B050 matches the Green 3 color
• If A2’s value comes from another formula (e.g., =D2/E2), replace the final A2 with that formula:

  =STYLE(IF(D2/E2<0.05, "font-color: #C00000", "font-color: #00B050"), D2/E2)
  

For Cells A3/A4/A5 (Comparing to B3/B4/B5) #

Use the same logic, but compare each A-column cell to its corresponding B-column counterpart:

• A3 formula:

  =STYLE(IF(A3<B3, "font-color: #C00000", "font-color: #00B050"), A3)
  

• A4 formula:

  =STYLE(IF(A4<B4, "font-color: #C00000", "font-color: #00B050"), A4)
  

• A5 formula:

  =STYLE(IF(A5<B5, "font-color: #C00000", "font-color: #00B050"), A5)
  

This keeps your calculated values fully intact while applying font color directly via formula—no text conversion required.

Excel Solution (Since Excel Lacks the STYLE Function) #

Excel doesn’t let cell formulas control font color directly, but you can use conditional formatting with formula rules to get the same result:

1. For A2:

   • Select A2 → Go to Home > Conditional Formatting > New Rule
   • Choose "Use a formula to determine which cells to format"
   • Enter =A2<0.05 → Click Format → Set font color to Red 3 → Click OK
   • Create a second rule for the same cell: Enter =A2>=0.05 → Set font color to Green 3 → Click OK

2. For A3/A4/A5:

   • Select A3 → New Rule → Formula: =A3<B3 → Format font to Red 3
   • New Rule → Formula: =A3>=B3 → Format font to Green 3
   • Use the Format Painter tool to copy these rules to A4 and A5 in one click

内容的提问来源于stack exchange，提问作者Nemgathos