typing in a new cell and carrying the formatting of the previous c

  • Thread starter Thread starter fadwa
  • Start date Start date
F

fadwa

how can i get the formatting done automatically in line with formatting of
the same row evertime i type in a new cell in that row? for example, i have
data in spread across A1:E1, and there is a special formatting for this set
of data, when i type into F1 i want the same formatting to carry forward.
what i am looking for is not a "paste formating" or "Format Painter" option.
 
You could use Conditional Formatting on the whole row, with a condition (for
active cell A1) of =NOT(ISBLANK(A1))
 
You need an event macro for that, something like this one:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 Then _
Target.NumberFormat = Range("A1").NumberFormat
End Sub

Post if you need help to install it!

--
Regards!
Stefi



„fadwa†ezt írta:
 
Back
Top