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
Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
linking cells and formatting 1
protect cell format 1
Conditional Formating with IF and AND formula 2
how to change color of cell based on contents of cell 2
Dynamically setting CELL COLORS based on TWO OTHER cell values 4

Top