How do I boldface specific cells of data table connect to graph?

[mcgoo98]

I am trying to boldface specific cells within a data table that I display
along with bar graphs. I need to differentiate between cells to identify
significance. I am struggling with doing this, either boldfacing the entire
data table or nothing at all. In the past, I've had to export into Corel
Draw and manually boldface the specific cells. Anyone else have this problem
that has figured out a solution? THANKS!

 

[Gord Dibben]

What would be the criterion for selecting "specific" cells to boldface?


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Too quick<g>

I'm thinking along the lines of Conditional Formatting but a macro could
also be used.


Gord

 

[mcgoo98]

Comparing columns. If cells in column A are values that are 2x higher than
values in column B, than the individual cells would be bolded. Example.
Column A Column B
4 3
5 1
7 2
8 6

I would be trying to bold the 5 and 7...

 

[Gord Dibben]

Select the cells in column A and Format>Conditional Formatting>Formula is:

=A1>2*B1

Format to Font>Bold and OK your way out.


Gord

 

[mcgoo98]

Thank you for your help. But that doesn't take care of my problem. That
allows me to bold or highlight in a data table. My problem is that when I
graph these values and add a data table to the chart (rather than using a
legend), the bold or highlighting does not transition into the chart. Do you
know of any way to boldface or otherwise differentiate between cells that are
part of a data table attached to a chart/graph? That is the problem I've
struggled with for quite some time now. Thanks!