Show results in bold if a cell is in bold

[Diana]

Good morning,

I have this sheet with some data and other one with results. The
results are calculated with hlookup from the data. Data that changes
weekly are introduced in bold. Is there any chance to show the results
of the data in bold in bold as well. I mean, if the data is in bold,
resulta must be in bold. If data is without format, must show without
any format. I supposed we would need to use a macro. Is it possible?

Thank you so much for you support

 

[Dave Peterson]

Formulas don't bring back formatting.

But maybe you could use a helper cell in the original worksheet that shows if
this is a change (put an X if it is and leave empty if it's not).

Then you could use that helper cell (same kind of =hlookup()) as the basis for
conditional formatting.

In fact, I'd use the same thing in the original data, too!

 

[Ron Rosenfeld]

Good morning,

I have this sheet with some data and other one with results. The
results are calculated with hlookup from the data. Data that changes
weekly are introduced in bold. Is there any chance to show the results
of the data in bold in bold as well. I mean, if the data is in bold,
resulta must be in bold. If data is without format, must show without
any format. I supposed we would need to use a macro. Is it possible?

Thank you so much for you support

Formulas and functions cannot return formatting.

It is probably possible to do what you want. It would involve either using
conditional formatting with "helper cells" on the "results" worksheet; or a VBA
macro.

But the actual solution will depend on the specifics of your implementation.

How do you know if the "Data changes weekly"?
--ron