VLOOKUP Retun formated cell (keep source formatting)

Hello All,

I’m creating an Decision Tree. (see attached example)
I made some progress but now I’m stuck.
When I select a data calcification in Cell B5 (as confidential or restricted) it is grabbing information from the Sheet “Requirements” and filling this information in cell D5 and D6.
The information form Cell D6 comes from “Requirements” Cell B24
I would like to copy the information (including the Source format and color(s)) to Cell D6 on the “SaaS Questions” TAB.

I can’t get it to work.
The second with I have is that the Cell D6 keeps following the selection I made in B5.
(When I hard copy the cell from “Requirements” B24 to “SaaS Questions” D6 , It will not change anymore when the selection is changed in cell B5 “SaaS Questions”

So I’m looking for a VBA or a triggered Marco to keep playing with the selections in Column B but use the information from the “Requirements” tab Incl the formatting of the refence cell

Emoes

Hello Mumps1,

This actually looking pretty good :-)
Can I ask to add one extra thing?
When Selecting "Confidential", "Restricted" this is copying the B24 (Requirements) to D6.
Would it be possible to copy another cell also based on another selection?
Something like:
Private Sub Worksheet_Change(ByVal Target As Range)

Please Login or Register  to view this content.

You see I'm not a VBA person, but with this, extra option I can remove the formula from Cell D6 and based on the selection put in any Value with keeping the format.
I hope I expressed my self clear enough.

Emoes.

Hello Mumps1,

This made me very happy.
Thank you for your help.
I have "add reputation"

Thanks again.

Emoes