Bold entire row if any cell in column S contains the word New

Posted on 2014-08-13
Last Modified: 2014-08-13
Could an expert provide me with the VBA code that will Bold entire row if any cell in column S contains the word New

Thanks in advance
Question by:Jagwarman
    LVL 10

    Expert Comment

    Do you need VBA code or just conditional formatting?

    Conditional formatting is simpler to implement.  Just enter the following as a formula for the entire block of data you want it to apply to:

    Open in new window

    Then set whatever formatting you want to apply.
    LVL 47

    Accepted Solution


    As VBA

    Sub macro()

    For Each c In Range(Range("S1"), Range("S" & Cells.Rows.Count).End(xlUp))
        If c = "New" Then
            c.EntireRow.Font.Bold = True
        End If
    End Sub


    Author Comment

    JEaston I thought of that but the word 'New' is removed later in the Macro and this makes the cells go back to regular Font. As thia is a small part of a much larger Macro I prefer to have VBA code. But thanks anyway.

    Author Comment

    Thanks Rgonzo exactly what I need.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now