Were are going to talk about the Format Painter most people are aware of the format painter
so for example we have two words here and one is formatted with a different type of
font and it is bold and so you just click on that and you click on the format painter
and then you can copy the format to another cell and that works very quick and very well
if you are stepping into some one else work sheet and you do not know how they have formatted
it it is an easy way to make sure that your information looks the same as theirs but there
is far more things that the format painter can do for you so let us go over a few of
them for example here I have a timesheet that done and I have set up the client name in
a particular font I have set up the shading and everything so now I would like to select
the whole sheet and copy the format I am not trying to copy the formulas or the information
I just want the formatting so what I am going to do is I am going to click the box between
the A and the I in this little square box here and then I am going to click on my format
painter and I am going to go to the next sheet and I am going click on that box again with
the format painter and instantly I have my formatting copied form one sheet to the other
this works well if you are changing the information and possible the formaulas and you just want
the formatting that you spent so long getting ready to copy to the next sheeet. If you notice
we are going to type in Your name here and it has copied the format of the font and the
size and it has also copied the merge and center here and on my other time sheet here
I have it formatted so that it turns red if it is over eight hours so what we are going
to do is we are type in 5, 5, 5, and then we are going to take an automatic sum
and automatically what ever I get here it turns red because it is greater than 8. so
we are not done with our tricks or our great benefits of the format painter let go on to
conditional formatting so here I have a task list that is quite a bit of information that
I have tried to conditionally format now the project starts on the first of may and ends
on the first of September and the total number of days is 123 the total days that we have
gone so far is 40 and I have done a little formula here saying dividing by the total
days that we have gone so far as apposed to the divided by the total days of the project
and we get 33% complete in time and I have this conditionally formatted so that if the
task percentage complete put in by the project managers and those that are less than the
33% will turn red. So what we are gong to do is we are going to click on the the task
here and we are going to go t o conditional formatting and we are going to go to manage
rules so you can see what I have done here and so I have if it is greater that 33% complete
it will turn green and if it is less than 33% it will turn red note that when I set
this up the b3 which is the percentage column I have taken the dollar sign out of the 3
so that indicating that this can be applied to other cells is this column now we are going
to go =OK further down we have task seven, eight , nine so what I am going to do is click
on task 1 that is highlighted in red and I am going to click the format painter and I
am going to appy it to taks 7, 8, 9 and there you see that the conditional formatting has
been copied from one cell to another so this saves a lot of time and a lot of calculation
Please subscribe