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))
--
David Biddulph

"fadwa" wrote in message
...
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 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:

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.