Can you link (pick up) the font colour of a cell from one worksheet to another?

[LynetteT]

I have a spreadsheet with several worksheets. The first worksheet does a VLOOKUP on all of the other worksheets. I want to change the colour of the font in some of the cells based on the information in there (this is arbitrary and cannot be worked out by formula) in the other worksheets, but I want the first worksheet that does the VLOOKUP to pick up the colour of the font from any of the other worksheets - is this possible?

[icestationzbra]

not unless there is VB code involved, as far as i know...

[bonny24tycoon]

Hi LynetteT,

Are the colors fixed. As an example : if the value is >50 the font color should be red?

If yes, this can be achieved with simple conditional formatting. If not, a VB code would be involved.

[LynetteT]

Hi LynetteT,

Are the colors fixed. As an example : if the value is >50 the font color should be red?

If yes, this can be achieved with simple conditional formatting. If not, a VB code would be involved.

The colors are not fixed. The same data will be in the cells, but only one of them might be highlighted. i.e. they will all have the same letters e.g. BH in them, but due to information that I have only one or two of these might be highlighted in red.

[LynetteT]

Thanks for your help. It looks like I may need to learn VB programming or work out a different way to do what I want.