Apply color of one cell to other

T

Tigerxxx

Hello,

How can I apply the color settings of one cell to another through a formula?
Ex- If cell A1 is filled with red color, I want cell B1 to be filled with
red color too based on the formula.
 
F

FSt1

hi
to answer your question....no, not through a fomula.
formulas return value to the cell in which they reside. they cannot perform
actions such as change formating, put values in other cells, copy, paste, etc.
but you might be able to perform what you want with conditionsal fomating.
post your formula and other conditions and i (or someone) might be able to
at least point you in the right direction.

regards
FSt1
 

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

Change Color of cell 3
Match table shading (color) to Visio color/Transparency 1
Tracked changes by multiple people modified to one 0
Transfer data between two tables 3
Fill tringle in a cell with color 1
Need help modifying code 0
How do I convert shading to highlighting for specific colors 8
how to format cells -fill color 2

Top