Conditional Formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that subtotals the Amount (Column C) after each Dept ID
(Column F) changes. Is there a way I can get each subtotal cell, which is in
column C, to BOLD? Thank you.
 
Add a conditional format to cell C2 that is a formula: $F2<>$F3 and set
the format to bold. Then copy this format down the column.

- John
 
I'm doing what you asked me to do, but I can't get it to work. Perhaps my
question should have been clearer. Is it helpful if you know that the number
of rows varies for each DeptId? I could be subtotaling amounts where the
DeptId is listed on 4 rows and then another DeptId might just have one row.
Does that help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting based on Text 2
Subtotals and Conditional Formatting 1
filtering subtotals and if functions 2
multiple subtotals 1
Excel VBA 1
Autosum column values, if separate column values equal certain val 1
Conditional formatting 1
Additonal info into newly created Subtotal row 1

Back
Top