<div>
Hope this helps<br />
<br />

<pre><code id="code-20-35126614-1">Sub Sample()
    If Range(&quot;A2&quot;).Font.ColorIndex = 3 And Range(&quot;A2&quot;).Font.Bold = True Then
        Debug.Print &quot;Font is bold and in Red Color&quot;
    End If
End Sub</code></pre>
<br />
Sid
</div>


Hope this helps



Sub Sample()
    If Range("A2").Font.ColorIndex = 3 And Range("A2").Font.Bold = True Then
        Debug.Print "Font is bold and in Red Color"
    End If
End Sub


Sid

<div>
# Select range you want to format<br />
# Choose Format|Conditional Formatting<br />
# From the first dropdown, choose cell value Is<br />
# from the second drop down select equal to<br />
# in the next column write goal<br />
# click on fromat button.<br />
# select the formating you want to apply
</div>


# Select range you want to format
# Choose Format|Conditional Formatting
# From the first dropdown, choose cell value Is
# from the second drop down select equal to
# in the next column write goal
# click on fromat button.
# select the formating you want to apply

<div>
Sorry. Please ignore my post. I misunderstood.<br />
<br />
Sid
</div>


Sorry. Please ignore my post. I misunderstood.

Sid

<div>
If you mean you want to use a formula in a cell instead of conditional formatting, then no, that is not possible.
</div>


If you mean you want to use a formula in a cell instead of conditional formatting, then no, that is not possible.

Book8.xlsx

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
I know about the powerful function of conditional formatting. However, I would like if there is a way to implement certain conditions also into a formula.<br />
E.g. IF in field A2 is stated the word &quot;goal&quot; have the entire line in bold or in bold and red font?<br />
thank you<br />
Nils<br />

</div>
</div>


Dear Experts,
I know about the powerful function of conditional formatting. However, I would like if there is a way to implement certain conditions also into a formula.
E.g. IF in field A2 is stated the word "goal" have the entire line in bold or in bold and red font?
thank you
Nils


IF conditions related to font and color

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.