I suck at Excel, so pls be gentle. I'm working on a document that has two worksheets (W1 and W2).

W1 will have a list of products and labor roles and respective prices for each.

My boss wants it so that when a sales team enters product and project roles on W2, the cell where the price is entered will turn green or red based on whether the price aligns with what's listed on W1.

How do I do this?

Looking to get out of a firm that does majority insurance defense and into BL commercial lit. Wondering if anyone has successfully done this as a first or second year, and if they have any advice on making the switch?

Lawyers in Public Accounting, what have your non-public accounting job experiences been like? If you’re currently in public accounting, are you happy where you’re at or do you aspire to do something different? I’m always curious to hear about career paths.

LETS GOOOO ITS SATURDAY!!!

Our company is going through a major transformation and there is quite a bit of resistance due to uncertainty and lots of broken promises. Are there any books you would recommend on how to change corporate culture and help employees adapt to change?

What are everyone's thoughts on resume services/coaching? I am a leader/exec that was laid off (first time) and have spent over 15 years in various roles such SVP Operations, Senior Director Product, VP Solutions, etc. at different companies.

I am struggling with putting my experience/qualifications on paper...

Prospecting Ae’s (or bdrs) are you getting a lower open rate/filtered by spam filters due to attaching a link, screenshot or pdf? If yes, I’m curious if it’s the same drop off rate for all or if it’s different

unhappy @ current agency & haven't sold any work in 8+ months. Went from overseeing jr teams & presenting to clients to being treated like an intern. Old cco said he'd hire me back. Bad career move?

Looking for roles on the Customer/Marketing/Sales Consulting side of things. MBA w majority of time in industry looking to make a switch.

Can anyone refer me for java developer role 3.11 yrs exp

Anybody know any good financial advisors? My husband and I are broke btw 😂😂😂

I have an offer for a senior technical accountant role in HCOL. The base is about 103K. But I'm required to work on-site basically every week day. Due to this, how much more % wise do you think I can reasonably try to negotiate for? Thanks!

Does anyone work at a firm where legal assistants don't do legal assistant things? For example, I have to do my scheduling and calendaring. I have to upload documents to our file management system. This morning, a name partners assistant didn't realize the name partner had a depo and didn't confirm it. This is how this firm as been for decades and it's incredibly frustrating to work this way. It's so hard to not stress over this daily.

Anyone work in nonprofit tax? What exit opportunities are available with 3-6 years experience? Hoping to be promoted to senior this year and curious what options exist with this specialized skill set.

What’s the market for RPA and AI projects like at the moment?

Salaam, unsure if this is the right bowl, but does anyone have any recommendations on books that discuss the history of Pakistan? It’s formation, etc. Thanks

Any idea what salaries youd be looking at working for a placememt agent? PE, RE, private debt etc

Does Deloitte provide cab facility?

I am in need of some advice I have a bachelors in healthcare administration. My long term goal would be a CEO of a hospital. I am looking at masters programs and need some advice as what to get my masters in. I could get my masters in healthcare administration but would like to look at something a little different maybe healthcare leadership or something. Anyone have some advice?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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.

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?