typing in a new cell and carrying the formatting of the previous c
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. |
typing in a new cell and carrying the formatting of the previous c
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. |
typing in a new cell and carrying the formatting of the previous c
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. |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com