Conditional Formatting in Excel

morinia used Ask the Experts™

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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel VBA Developer
Top Expert 2014
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"

moriniaAdvanced Analytics Analyst


I had to change $A2 to $A1  sorry for the typo.
Glenn RayExcel VBA Developer
Top Expert 2014

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.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial