conditional format

J

jlp

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
 
B

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)

jlp said:
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
Click to expand...
be instructed to go to a lookup table and find the name and then use its
formats?
 
D

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
[email protected]
jlp said:
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
Click to expand...
be instructed to go to a lookup table and find the name and then use its
formats?
 
Top