Conditional Formatting in Excel

Posted on 2014-08-08
Last Modified: 2014-08-08

I would like to apply a format of bold and red font to column "B" in Excel if the value in column A on the same rowl has the value "Count".

"Count" was obtained by subtotal function in Excel.  I am trying to bold and put in red font the results from the subtotal.

Is there a way to do this?
Question by:morinia
    LVL 27

    Accepted Solution

    Yes you can.

    I assume you're using Subtotals to count the number of values in each subsection.  You can create a conditional format to check for "Count" in column A like so:
    conditional formatting on "Count" in subtotals
    You'll just highlight all the cells in column B that apply, add the conditional formatting rule as shown above and then note the formatting change (bold, red font).

    NOTE:  if you remove/re-add subtotals, the formatting will likely not appear.  You'll have to edit the conditional formatting rule again to ensure that it has the formula =RIGHT($A2,5)="Count"


    Author Closing Comment

    I had to change $A2 to $A1  sorry for the typo.
    LVL 27

    Expert Comment

    by:Glenn Ray
    FYI:  I had to use $A2 in my conditional formatting formula because my range to apply the rule started in the second row (B2:B27).

    Nevertheless, I'm glad it works for you.


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    754 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

    24 Experts available now in Live!

    Get 1:1 Help Now