how do I use a formula to copy a cell including formatting

[Guest]

I need to set up a condition that as a result will copy a specific cell
including it formatting.

an alternative is to use a formula to copy a cell and somehow apply formatting

 

[Earl Kiosterud]

Andy,

A formula only returns a result, which appears in the cell in which the
formula lives. It can't "do" anything, like put anything in another cell.
You probably need an event-fired macro to copy your formula.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I need to set up a condition that as a result will copy a specific cell
including it formatting.

an alternative is to use a formula to copy a cell and somehow apply

formatting