Help with scroll table

%3CLINGO-SUB%20id%3D%22lingo-sub-1514525%22%20slang%3D%22en-US%22%3EHelp%20with%20scroll%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514525%22%20slang%3D%22en-US%22%3EHello%20please%20could%20anyone%20help%20me%20with%20an%20Excel%20query%3F%20I%20had%20an%20original%20table%20with%20conditional%20formatting%20to%20highlight%20certain%20values%20red%20Amber%20and%20green.%20When%20I%20copy%20the%20table%20to%20create%20a%20scroll%20bar%20I%20can't%20seem%20to%20figure%20out%20how%20to%20preserve%20the%20conditional%20formatting.%20Any%20help%20would%20be%20appreciated.%20Thank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1514525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515988%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20scroll%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F724944%22%20target%3D%22_blank%22%3E%40AndyL20%3C%2FA%3E%26nbsp%3B%2C%20what%20do%20you%20mean%20when%20you%20say%20you%20are%20creating%20a%20scroll%20bar%3F%20Can%20you%20upload%20a%20sample%20file%20without%20any%20confidential%20info%20to%20help%20see%20what%20the%20issue%20is%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516185%22%20slang%3D%22de-DE%22%3ESubject%3A%20Help%20with%20scroll%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516185%22%20slang%3D%22de-DE%22%3ESince%20I%20didn't%20quite%20understand%20what%20your%20plans%20are%20...%20I%20say%20...%20Maybe%20...%20but%20only%20maybe%20that%20will%20help%20you%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20insert%20menu%20options%20%3CBR%20%2F%3E%20(in%20the%20ribbon)%20%3CBR%20%2F%3E%20insert%20content.%20%3CBR%20%2F%3E%20Keyboard%20shortcut%3A%20Press%20CTRL%2BALT%2BV.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Read%20more%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Feinf%25C3%25BCgeoptionen-8ea795b0-87cd-46af-9b59-ed4d8b1669ad%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Feinf%25C3%25BCgeoptionen-8ea795b0-87cd-46af-9b59-ed4d8b1669ad%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Regards%2C%20%3CBR%20%2F%3E%20Nikolino%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518440%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20scroll%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518440%22%20slang%3D%22en-US%22%3ESo%2C%20on%20the%20original%20data%20tab%20I%20have%20(before%20removing%20for%20uploading)%20about%2080%20rows%20of%20data.%20As%20I%20want%20to%20display%20this%20info%20on%20a%20dash%20board%2C%20to%20save%20space%20I%20created%20a%20table%20with%20a%20scroll%20bar%20(scroll%20data%20tab)%20so%20I%20could%20use%20the%20scroll%20to%20display%205%20rows%20at%20a%20time%20on%20the%20dashboard.%20However%2C%20the%20original%20data%20tab%20as%20you%20can%20see%20has%20conditional%20formatting%20on%20the%20last%20column%20to%20highlight%20cell%20values%20as%20red%20Amber%20green.%20When%20using%20the%20scroll%20table%20on%20the%20scroll%20data%20tab%20I%20can't%20seem%20to%20figure%20how%20to%20preserve%20the%20conditional%20formatting%20to%20highlight%20the%20values%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hello please could anyone help me with an Excel query? I had an original table with conditional formatting to highlight certain values red Amber and green. When I copy the table to create a scroll bar I can't seem to figure out how to preserve the conditional formatting. Any help would be appreciated. Thank you
3 Replies
Highlighted

@AndyL20 , what do you mean when you say you are creating a scroll bar? Can you upload a sample file without any confidential info to help see what the issue is?

Highlighted
Since I didn't quite understand what your plans are ... I say ... maybe ... but only maybe that will help you

Einfügeoptionen
Menü Optionen einfügen (im Menüband)
Inhalte einfügen.
Tastenkombination: Drücken Sie STRG+ALT+V.

Read more here: https://support.microsoft.com/de-de/office/einf%C3%BCgeoptionen-8ea795b0-87cd-46af-9b59-ed4d8b1669ad

Regards,
Nikolino
Highlighted
So, on the original data tab I have (before removing for uploading) about 80 rows of data. As I want to display this info on a dash board, to save space I created a table with a scroll bar (scroll data tab) so I could use the scroll to display 5 rows at a time on the dashboard. However, the original data tab as you can see has conditional formatting on the last column to highlight cell values as red Amber green. When using the scroll table on the scroll data tab I can't seem to figure how to preserve the conditional formatting to highlight the values