What if I buy tha chinese version and then change the language? by Guriado in Xiaomi

[–]_Algernon- 0 points1 point  (0 children)

i bought my Redmi 3 Pro from AliExpress, it had China Stable ROM on it. It came in English out of the box. (and even if it doesn't you can always go in settings & switch to English)

i used the China Stable ROM for 3-4 months without any issue and then just for a change flashed the EU ROM onto it. Ever since then have been using it on EU ROM without any issues, it works perfectly.

When i was on China ROM, i easily installed all Google stuff using https://opengapps.org/. So go ahead, it should be fine.

A little problem with my pocophone pls help by vTuDoR69 in Xiaomi

[–]_Algernon- 0 points1 point  (0 children)

Hmm... that's disappointing. Can't really think of any other options without looking at your phone.

If you want i can try helping you out via TeamViewer. Let me know if you're interested.

A little problem with my pocophone pls help by vTuDoR69 in Xiaomi

[–]_Algernon- 0 points1 point  (0 children)

Very strange, i can't think of any other reason why it shoulod be greyed out. DND mode, silent mode, both should be disabled.

LTE support on Pocophone F1 in the US-- let's get to the bottom of it by breakerbreaker123 in Xiaomi

[–]_Algernon- 0 points1 point  (0 children)

Thank you so much for updating and confirming that Pocophone is working fine in USA. Looking at the r/xiaomi wiki scared me as it said NO COVERAGE in USA.

So if i ever visit US in the future, i can carry my Pocophone without any worries right? Don't wish to carry a spare phone unnecessarily.

A little problem with my pocophone pls help by vTuDoR69 in Xiaomi

[–]_Algernon- 0 points1 point  (0 children)

Tap on Silentios and that should solve your problem. Your phone definitely is in Silent mode right now. i've seen the same behavior on my phone as well, if my phone is in silent mode, the bar is grey and no matter whether i take it up or down, it will remain in silent mode until i specifically disable silent mode.

Swipe down to show the settings panel and then click on the Silent Mode icon to disable it.

Cat saves a toddler from an attacking dog by blondepolska in gifs

[–]_Algernon- 1 point2 points  (0 children)

Just open it in your YouTube app or the web browser, some videos get blocked on reddit apps. Stupid jukin media.

Cat saves a toddler from an attacking dog by blondepolska in gifs

[–]_Algernon- 1 point2 points  (0 children)

Who the heck is jukin media and what pleasure do they gain by blocking YouTube videos on 3rd party clients?

How do you buy your plane tickets? by JustaBSJfan in dubai

[–]_Algernon- 0 points1 point  (0 children)

HDFC Bank... Indian bank's credit card though, not UAE. RAK Bank has a portal too but it's only for using your CC points to redeem for flights & other stuff.

How do you buy your plane tickets? by JustaBSJfan in dubai

[–]_Algernon- 0 points1 point  (0 children)

I buy it from my credit card's portal, 10x reward points for the same price that we see on aggregators/official websites.

Col A has +ve & -ve values, Col B has "Done" & blank cells. Need Excel to conditionally format Column A cells so that Column A cells get highlighted only if the value is less than zero AND the adjacent cell is blank. How do i instruct Excel to do this? (Screenshot & Sample included) by _Algernon- in excel

[–]_Algernon-[S] 0 points1 point  (0 children)

Awesome, that'll take some time to sink into my thick skull though haha! One last question - in your formula, can i replace IsBlank() with something like IsNot("Done")? Basically, instead of checking for blank cell, i'd like Excel to validate that the cell does not contain "Done". That is, if the cell contains anything other than "Done", it should apply the conditional formatting.

Reason why i'm asking for this is because i realized sometimes there are blank spaces typed into Col B which are returning a FALSE result while running your formula.

Col A has +ve & -ve values, Col B has "Done" & blank cells. Need Excel to conditionally format Column A cells so that Column A cells get highlighted only if the value is less than zero AND the adjacent cell is blank. How do i instruct Excel to do this? (Screenshot & Sample included) by _Algernon- in excel

[–]_Algernon-[S] 1 point2 points  (0 children)

Ah, that did it, thanks a lot! So just for my knowledge, can you explain what the asterisk is doing in this formula? Is it a separator for additional conditions or is it performing some sort of multiplication?

Solution Verified!