vlookup and bring the "font color" of the cell across?

P

Pete_UK

If that font colour has been set by means of conditional formatting,
then you can apply the same CF rules to the cell containing VLOOKUP.

However, if you have set the colour manually, you will not be able to
bring that back to the cell with the formula in, as a formula can only
return a value, not a font.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
How to modify and updte specific styles for specific paragraphs across the document 0
Match table shading (color) to Visio color/Transparency 1
Fill tringle in a cell with color 1
Links 2
Tracked changes by multiple people modified to one 0
Font drop-down menu very slow 0
How to vlookup and bring over fill colors as along with the data 1

Top