Excel's Conditioning Formatting has a mind of it's own, or is possessed. You define the rule, designate the reference cell/range (goodness knows NOT to use arrow keys within the Edit Rules box... cont

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

Conditional formatting is like Neo in the matrix, an unbalanced anomaly which everyone in Microsoft continues to ignore


It’s definitely a glitch in the Matrix


Yeah, I’ve had this happen too. It’ll go to like row 1737848 for no reason. I just always go back and update it in the Manage Rules. It’s annoying but at least I know it consistently happens now.


As everywhere in Excel you can toggle between navigating within the formula/text and between cells by pressing F2. Do that and you won't have to worry about pressing your arrow keys anymore.
Is it possible that you have selected a cell or range which is not within the range of the cells to be affected by the conditional formatting? If so, this could be a reason for your problem.


How are you referencing the column A?
E.g. A1:A500, A:A, $A$1:A1 ?

I have no clue, if there could be the solution, but might be worth a try. Do you have the same problem, when choosing the range with your mouse?

At least the F2 trick should work for sure.

...then lo and behold, the reference cell/range jumps to some random row number. The work around for me has been: 1. Make sure the cursor is on A1 for the rules affect col A, 2. Click Apply and then change its random update of cell row. Anyone else experienced this?

$A1 = whatever
Applies to #$A:$CD

Related Posts

Helping a friend get the $1200, he hasn’t done his 2018 taxes. Does anyone know a way to e-file a prior year’s taxes for NY State? I’ve looked all over and can’t find a way...


Has anyone considered becoming a real estate agent just to save on those RE agent fees? If you do just one transaction per decade for yourself, seems like you'll still do better even considering ongoing TREB/OREA/brokerage fees. Need to spend $5k initially on courses/exams and 6-12months of time, but seems to make sense long term. Am I missing anything?


Curious to know has anyone stumbled upon a bar(cocktails, drinks) that has also nailed social accounts so good so that besides their bar offerings people also cant wait to consume their content?


Hi All,

My LWD is today, 30sept.

Can I expect salary today?

Or have to wait for FnF?

Thank you.


Has anyone thought of doing underwriting as a side business?


Looking to date a republican girl. It’s almost impossible in DC area…


Does anyone live in Milieu in west loop? What are your thoughts on living there and are there other good parking options besides there garage? (We have 2 cars and $600/mo. in parking seems too brutal)


First fly day of the year. SAN.

Post Photo

Hey just wanted to check if anyone (Australia) knows senior consultant banding for Monitor Deloitte? Just got an offer and it's WAY below my expectations.

Thanks in advance!


Does anyone have a recommended third party social platform that allows posting multiple images and stories to Instagram? HootSuite doesn’t do it, and Loomly doesn’t seem to. More costly ones? Sprinklr, AdobeSocial, Sprout Social?


Did Rauxa become FKA?


11 likes please


Hey guys, we are only a few days away. Please don’t forget to vote in person next week. America is counting on you. Keep it great 🇺🇸 🦅


Hey investors - question from the other side: when you’re looking to invest, what are the biggest components you look for?


Anybody who covered Zion and bryce national park in a single trip, which place would you recommend to stay over the night?


Are there remote entry jobs in the real estate industry? I’m getting depressed by the idea of just staying home with my newborn and not being able to work. I need ideas for positions please. Thanks


Any recommendations on where to stay in Barcelona? Going with a group of friends so wanted to stay in an Airbnb but the reviews haven’t been so great

Which company to join in terms of growth and job security:
Societe generale
Wissen technology
Algonomy (Manthan)
MYn super app


Hi All,
I am looking job in the SAP Data Intelligence field.

Can anyone refer me for the tech?


Additional Posts in Excel Genius

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?


Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted


Dear auditors, please explain how you pick samples for substantative testing.


Do you still use index match? Is it (Always) Possible to switch to xlookup?


Coolest, best, or nerdiest thing you've been able to do with Excel?


Does anyone know how to reformat a date from yyyy-mm-day to month-day—yyyy?


Best way to visually display trending data on sales when looking at how a few factors influence volume and price? Also any tips for including both in the same chart?

What are your favorite excel macros to make you more efficient at work?


I have a spreadsheet that includes these columns: total AUM of firm X, % of AUM allocated by X to sector Y, % to sector Z, and so on (one column for each sector). Goal is to present in tabular form...

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.


There has to be a way to restrict access on a worksheet so that only specific cells can be edited.

No matter how many times I’ve tried to automate and simplify generating reports to just inputting data into specific highlighted boxes, someone just have to try to edit a completely different cell then asking why the worksheet is “broken.”


Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.


Has anyone used VBA to create multiple what-if data tables before?

I have a table of different tickers of stocks and their according prices on different dates and times (hour and minute shown, no seconds). I'm trying to extract a singular price for each ticker based on date and time, but am having trouble doing so as there's multiple prices for each time (i.e. one row has $10 for 2:50pm, another has $11 for 2:50pm, etc) and was wondering if there was a way to pull only one price, let's say the highest, for a time?


My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?


I'm stumped!
Coworker creates "Sheet A" with invoice numbers
I use Monarch to extract invoice #'s and amounts from another report.
I do a pivot table to compile amounts by invoice. I copy those results to "Sheet Z".
I then do an @vlookup on Sheet A referencing Sheet Z (just the invoice # and amount).
It isn't working unless I go to Sheet Z and type over the invoice # (same number)! All invoice #'s are absolute and in the same font & alignment. Workbook has 10 yrs data. Has worked in past!


Hello! I need to improve my excel skills. I know how to do some basic stuff but I need to do more. A client was teaching me how to use vlookup and I felt so useless! I decided to do something about it. I typed excel in udemy and there were so many results, I immediately became overwhelmed. Which one is the best? And shortest? Thank you!


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

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?


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


Embed this post

Copy and paste embed code on your site


Download the
Fishbowl app

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

A phone with Fishbowl app

Send download link to your phone


Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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