Forum Discussion
Copy content and format of a cell in a formula.
So cell A1 says: Alex if I go to A2 and put in the formula "=A1" This will give me: Alex However I want to keep the color red and the background color if there is one as well as "bold" or u...
So I work on a schedules for films production (commonly called "callsheets"). Now that sheet contains a lot of information and is often very busy looking and written quite small. I like to make a printable blowup of portions of the sheet that I can distribute to certain department.
So for example:
Actor 1 so supposed to be on the make up chair at 7:00 with Suzie
and Actor 2 need to be on the make up chair at 7:00 with Julie and so on.
So I usually color code it because there is no place to put the name of the actual make up artist for each actor. And yes its arbitrary in the sense that Suzie and Julie decide who does the makeup for whom. But then it means that, in the blow up portion, I need to color code it again. its not a huge deal but I like to make is as efficient as possible. I guess I could record a macro that copies/paste and make bigger the first board in a different sheet.
Anyways thanks for the feedback I thought there was a very simple solution to this that I wasn't aware of. And every time I searched I didn't get the answer I was looking for so I tried explain it in more details here.
So for example:
Actor 1 so supposed to be on the make up chair at 7:00 with Suzie
and Actor 2 need to be on the make up chair at 7:00 with Julie and so on.
So I usually color code it because there is no place to put the name of the actual make up artist for each actor. And yes its arbitrary in the sense that Suzie and Julie decide who does the makeup for whom. But then it means that, in the blow up portion, I need to color code it again. its not a huge deal but I like to make is as efficient as possible. I guess I could record a macro that copies/paste and make bigger the first board in a different sheet.
Anyways thanks for the feedback I thought there was a very simple solution to this that I wasn't aware of. And every time I searched I didn't get the answer I was looking for so I tried explain it in more details here.
And if the color coding is a matter of the color corresponding to the make-up artist, that could easily be done by means of Conditional Formatting. Or if it's the actor, same thing.
It IS a simple solution.
https://exceljet.net/lessons/what-is-conditional-formatting
https://www.youtube.com/results?search_query=conditional+formatting+excel
It IS a simple solution.
https://exceljet.net/lessons/what-is-conditional-formatting
https://www.youtube.com/results?search_query=conditional+formatting+excel