In a function, How do I copy the cell color as well as text

G

Guest

All I want to do is to say for example that Cell A1 is equal to Cell G8 and
have A1 contain the same text as G8 and have the same fill colour
 
G

Guest

In cell A1, put the formula =G8 and that will cause A1 to display the same
VALUE as is in cell G8. It will not transfer the cell color though.
However, if cell G8 is colored by Conditional Formatting, then that same
format can be applied to A1 and it's color will follow suite.......

hth
Vaya con Dios,
Chuck, CABGx3
 

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

Multiple function queries in same cell 2
Trying to highlight cells that have the same value as the active c 9
LOOKUP/IF Formula Help!! 1
Function for summing or counting cells based on a specified fill color 2
I am trying to use the IF and SUMIF function on Excel 8
Can i use the IF condition to import an image or change a cell col 1
Dependent List "Index" Problem 2
Reference a variable declared in VBA 3

Top