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.