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.