how to copy cell value from one sheet to another with the same formatting

[allexbyta]

hello, community.

I'm trying for 2-3 days to make a Microsoft Access Database for a schedule at my work - 24/7 x6 people. it's too hard for me and I'm back to excel.

at the moment I'm trying to bring the information (text) from sheet 2 to sheet 1 but i want to keep the text formatting ( only the text color I'm interested , not the size or font)

the formula I have now it's like

=Sheet2!D94&"("&Sheet2!E94&") ("Sheet2!$F94&"), ("&Sheet2!J94&") ("Sheet2!$K94&")" etc... many other values

I must say it's a a schedule for the entire year in 3 shifts 24/7 for 6 people / shift and I'm trying to make it easy to read.

So can u help me copy the cell value from one sheet to another and keep the text collor from sheet 2 ?

Thank you in advance.

 

[Joe4]

Welcome to the Board!

Native Excel formulas only act on the values of cells, not on the formatting.
If you want to copy formatting from one sheet to another and not do it manually, that will require VBA.

However, you may want to pause before totally giving up on Micorsoft Access.
There are many pre-built Access Database Templates for things like this.
If you do a Google search on "Microsoft Access Scheduling Template", you will find many hits.
There are usually free offerings and ones you can purchase.
You may want to peruse those and see if you can find one that is already built for you that you can use.