conditional format

[Guest]

Can you tell a cell to use the format of another cell
In otherwords, if a cell has a certain name entered in it, the cell would be instructed to go to a lookup table and find the name and then use its formats

 

[Bob Phillips]

and now a 3rd time!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Can you tell a cell to use the format of another cell?
In otherwords, if a cell has a certain name entered in it, the cell would

be instructed to go to a lookup table and find the name and then use its
formats?

 

[Don Guillett]

try this macro assigned to a button or shape to copy the formats of the cell
you specify to the active cell.

Sub copyformats()
Range(InputBox("Cell to copy")).Copy
ActiveCell.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone
Application.CutCopyMode = False
End Sub
--
Don Guillett
SalesAid Software
(e-mail address removed)

Can you tell a cell to use the format of another cell?
In otherwords, if a cell has a certain name entered in it, the cell would

be instructed to go to a lookup table and find the name and then use its
formats?