How to perform Partial format painting?

[jb]

I have an excel sheet "sheet1" in which the cell values are frequently moved to other cells manually. Due to that cell borders and conditional formatting formula for those cells also move with cell.

I have created one blank sheet "sheet2" with required borders and conditional formatting formula.

I have written one macro which is automatically executed when any cell changed in sheet1. Macro does format painting of sheet2 on sheet1. This works nice.


My problem:

I manually need to underline some cell values on sheet1. This cells are not fixed and not based on any condition. Now what happens, when cell value change, due to macro I am not able to preserve the underline.

Is it possible to preserve it?

How can do partial format painting?

Help me please. It is very urgent.

 

[Hui]

JB


If there is any criteria to why those cells are selected you could use Conditional Formatting


What makes you, or the user, select and place a line below a particular cell?

 

[jb]

It is user who is placing line below a particular cell. Basically, sheet1 contains timetable of a school. And a user is maintaining time table in such a way that whenever any teacher is absent, user is changing all the cells where the teacher name is present and those cells are filled with name of any teacher who is free. So this names are placed manually. And to show the extra class given to any teacher, a line is placed under name of a teacher to indicate that it is an extra class given.

 

[NARAYANK991]

Hi ,


Does your macro which does format painting of Sheet2 on Sheet1 have a statement like ClearFormats ?


Instead of doing this , since it will delete even manually inserted formats , can you use FormatConditions.Delete ?


Narayan