conditionally color font of formula result

[bristly]

I have a list of clients, some of them with additional info. I'd like the additional info to by greyed out (the semicolon controls this):

Client 1 name; Additional info
Client 2 name; Additional info

BUT
the text is a formula result. I mean the clients are listed in data-sheet but presented in report-sheet.

Can this be done?

[Norie]

Short answer, no.

[bristly]

:'-(
Thank you.

[Norie]

You don't want to know the long answer?

[bristly]

Is the long answer yes ?
Ok, I wanna know it whatever it is.

[bristly]

Still wondering what is the long answer .

[Norie]

Well it's not very long and now I come to think of it might not be suitable.

Basically, you could use code to copy/paste special values to get rid of the formulas and then format the values as required.

[bristly]

Ok, I may try it this way one day. But it looks like a lot of work.
Thank you, Norie

[Norie]

What formatting is it you want to apply?

If it's as simple as that in your first post it shouldn't be too complicated.

[bristly]

Yes, the formatting should look like the example in my first post.

[Marcol]

Try adapting this macro

Rather than overwriting your formulae this puts the result in a seperate column
With your data in A1 Down

Please Login or Register  to view this content.

[bristly]

Looks nice, Marcol. Thank you!