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!

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


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 13:42:02 -0700, mcgoo98
wrote:

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!

Too quick<g

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


Gord

On Tue, 14 Apr 2009 14:11:45 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 13:42:02 -0700, mcgoo98
wrote:

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!

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" wrote:

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


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 13:42:02 -0700, mcgoo98
wrote:

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!

Select the cells in column A and FormatConditional FormattingFormula is:

=A12*B1

Format to FontBold and OK your way out.


Gord

On Tue, 14 Apr 2009 14:27:06 -0700, mcgoo98
wrote:

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" wrote:

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


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 13:42:02 -0700, mcgoo98
wrote:

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!

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!

"Gord Dibben" wrote:

Select the cells in column A and FormatConditional FormattingFormula is:

=A12*B1

Format to FontBold and OK your way out.


Gord

On Tue, 14 Apr 2009 14:27:06 -0700, mcgoo98
wrote:

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" wrote:

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


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 13:42:02 -0700, mcgoo98
wrote:

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!