Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny
Posting as :
works at
You are currently posting as works at

LGBTQ

funnylike

Lol

Go to Page Layout, pick a different color scheme and (voilà!) the table will change color.

Alternatively, in Table Design you can change the color scheme of individual tables.

No mysterious meaning behind any of this.

like

That's not what I mean. Tables color-coded by default could be indicative of having a query as a data source, for example

Lol Accenture color palette maybe

likefunny

Is it not just a format option?

likehelpful

No

You all need to check your egos. SMH

Go and learn something.

https://www.airweb.org/article/2020/02/20/excel-power-query-saves-time

Post Photo
like

Hahaha thanks for posting though

I HAVE TO KNOW NOW

like

Purple? Wdym

OP, could you share your color coding. I am just curious what you learned and w he at was hammered into you 😂

Related Posts

Any men’s jogger sweatpants that people really like?

Any recommendations for men’s workout/athletic shirts (<$75)? Looking to finally upgrade from basic cotton/blend tees.

For reference, I’ve tried a few Rhone shirts and they are fine, but looking for something made of thinner material.

like

Anyone from GSK who can help with some questions?

30/F/(currently) Tampa, FL 🐠🏝 👱🏽‍♀️ Serious relationship only. Fit, cute, intellectual looking for her soulmate 💕

like

Who else is buying?

Sounds about right

Post Photo
likefunny

How is current Hybrid model in BNY Mellon & how will be hybrid model in next year ?

like

Could someone please refer me at JPMC for Java developer with 3.1 YOE, if you can. LWD Oct 26

I need 11 likes for DM

like

Could someone please provide inputs on below 2 orgs have offer from both of them.

Tech stack- java , microservice developer YOE- 7 years

CBRE - 26fixed +2 rrb + 2 JB(after providing 31.5 ctc counter offer , 28 fixed 2.8 variable)
UST global - 31 fixed + 1.5 variable + 2 JB

Can anyone from @CBRE suggest what is the package they're providing , i think i am being lowballed by the HR CBRE UST Global.

like

Just went from 5th to 2nd and would love to know classroom management ideas. Anything to stay away from? Thanks!

like

Any L&D nurses in Birmingham, AL? Moving there soon and wondering how much of a pay difference there will be compared to where I am now. Any hospitals to avoid?

like

Any one got the retention offer from TCS ?

like

Hi everyone,

Got an offer from

Infor
Thomson Reuters
Telstra
FICO
Bayer with almost same package.

Please help me which is the good company to join.

Thanks in advance.

like

Anyone familiar with Ephesoft Transact that would let me pick their brain?

like

I'm not hung up on PE/buy side exits, not closed off but nbd. Would be just as happy to stay and make MD (or exit into corp dev if I want an easier life when I'm older)

My dilemma:

I'm at a LMM investment bank. Can get crazy sometimes, but otherwise chill. Typically done around 7-9 pm, had maybe three 1 am nights. Haven't worked a weekend in over a month. Fridays almost always done at 5 pm.

Have an offer at a reputable MM bank but probably pretty sweaty. Worth the move?

like

It's sad to see people with 2-3 years of experience getting paid more than you when u have double the experience. 😄 Best part is they are still complaining of getting less. Well I guess you should never settle. New gen is giving a hard time to the experienced folks. I think this is the high time to upgrade your skills. Come out of your comfort zone and start looking for new opportunities. I think this is the best time to switch if u haven't already in quite some time.
Thoughts 💭 ???

like

How much do SAP principals make with about 8 yoe

like

Joining Google in a few weeks and assuming I will be moving to the Bay Area sometime this year. For people who have kids, what do you do about schools? My wife and I are looking to buy a place but most the public schools in the South Bay are rated terribly. It’s good to note we don’t have kids yet but are trying to think longer term. Are schools even considered in the resale value of a house? Thoughts and insights appreciated!

like

Additional Posts in Excel Genius

What would you consider "Advanced" or "Expert" level Excel usage?

like

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

Anyone have a good source to learn sql

like

What is the best online tool to pick up VBA?

likesmart

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Any book recommendations on excel modeling for real world business applications?

like

How long did it take you to become good at excel? Like fast?

like

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal