Conditional Formatting?

D

djn

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.
 
J

John Michl

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
 
D

djn

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?
 
Top