Manually combing through spreadsheets with large datasets can be a massive headache at times. Luckily, conditional formatting exists in Microsoft Excel specifically for this reason. This automation helps you visualize your spreadsheet in a completely different way, allows you to find important data quickly, and also makes your spreadsheet much more appealing to the eye. Excel even makes it easy to find - Conditional Formatting options are front and center on the Home tab.

While not as common anymore, dual-Ethernet port motherboards can still be found on the market. Some gaming motherboards have Gigabit and 2.5Gb Ethernet ports, with one being a Realtek NIC and the other being Intel. Most PC users might never have used a motherboard with two Ethernet ports, as a single port has become standard on consumer motherboards.

Michelle Yeoh as Emperor Philippa Georgiou. | Screenshot: YouTube There’s a lot of Star Trek: Discovery in the official trailer for the Star Trek: Section 31 movie that Paramount Plus just released — big drama, explosions, and some looming threat that’s “unlike anything that Starfleet’s ever seen.” The trailer shows off a little more of the film, with moody corridors, some sort of electrified space ball, and brief looks at the spaceships that the show will feature. It also devotes more time to characters besides Michelle Yeoh’s Emperor Philippa Georgiou — namely Omari Hardwick’s Alok Sahar and Kacey Rohl’s future Enterprise C captain, Rachel Garrett. It’s still a mystery what trouble Emperor Philippa is leading her team into, though.Philippa will work with a team that also includes a pointy-eared alien named Fuzz (Sven Ruygrok), an empath named Melle (Humberly Gonzalez), the exoskeleton-wearing Zeph (Rob Kazinsky), and a Chameloid shapeshifter named Quasi (Sam Richardson). Star Trek: Section 31 starts streaming January 24th on Paramount Plus.

There is no shortage of Excel alternatives out there. Every time a new Excel challenger arrives in the market, they come with tall claims to replace Microsoft’s legacy software. Declared dead countless times, Excel stubbornly refuses to fade away. Because beneath its seemingly simple interface lies a powerhouse of versatility and functionality that continues to prove invaluable for individuals and businesses alike. In this post, I will explore key reasons why Excel will never truly be replaced.

Many aspects of Windows have remained relatively untouched for years, even in Windows 11. For instance, while other operating systems have made better and more visually helpful battery indicators, Windows has had the same old for who knows how long now. Fortunately, a hidden feature within the Windows 11 Dev build shows us what we might expect in the future, and it looks great.

DDR5 RAM is the latest standard for system memory inside desktop and laptop PCs, replacing DDR4. This new standard promises higher capacities, better efficiencies, faster speeds, and advanced features not typically found on older DDR4 RAM modules. If you're on the fence about deciding between DDR4 and DDR5 or want to know what you can enjoy by upgrading to a CPU and motherboard supporting DDR5, we've rounded up some reasons why DDR5 is better than DDR4.

The power supply unit (PSU) is one of the most essential components of any PC build. The PSU, as the name suggests, is what powers up everything inside your PC. Without it, nothing would work, and you would be left with a very useless and large paperweight. While it is essential, it is also one of the components that gets looked over quite a bit, and people even try to cheap out on their PSU, which is never advised.

Image: The Verge X has given Grok a new AI image generator model called “Aurora” that seems to create far more photorealistic imagery than Grok’s other image generator, with similarly few apparent restrictions on what it will produce, TechCrunch reports. Like Grok, anyone can use Aurora. It lives in a new “Grok 2 + Aurora beta” option in the Grok model selector, though you’ll only get a few queries before you hit the X Premium subscription paywall and have to wait.TechCrunch found that the model, which X employee Chris Park posted is available this morning, was willing to create copyrighted characters and public figures, including Mickey Mouse and “a bloodied Donald Trump,” but that it “stopped short of nudes.” Its lack of restrictions isn’t surprising, given our experience with Grok’s other model. In another example highlighted by TechCrunch, an X user showed off AI-generated images of Ray Romano and Adam Sandler in the X post below — both realistic, but with some very obvious weirdness when it comes to human anatomy and continuity. Behold my images using the new Grok @grok image generator Aurora: 1. Ray Romano and @AdamSandler on a sitcom set pic.twitter.com/2V491RdjMF— Matt (@EnsoMatt) December 7, 2024

Photo illustration by Cath Virginia / The Verge | Photos by Jerod Harris, Chesnot, Getty Images With just weeks left to pass legislation before Congress adjourns, X CEO Linda Yaccarino announced she worked with the authors of the Kids Online Safety Act (KOSA) to update the bill in what seems like a play to win over the Republican House leaders standing in the way of it becoming law. The striking announcement is the latest example of how Elon Musk and his companies are taking on significant roles in influencing government output. While it’s not unusual for outside stakeholders, including companies, to weigh in on pending legislation, the fact that the bill’s sponsors, Sens. Richard Blumenthal (D-CT) and Marsha Blackburn (R-TN), announced X’s input indicates they view it as helpful to the bill’s chances of passing.“Led by X, the new changes made to the Kids Online Safety Act strengthen the bill while safeguarding free speech online and ensuring it is not used to stifle expression,” Blumenthal and Blackburn said in a joint statement. “These changes should eliminate once and for all the false narrative that this bill would be weaponized by unelected bureaucrats to censor Americans. We thank Elon and Linda for their bold leadership and commitment to protecting children online and for helping us get this bill across the finish line this Congress.” KOSA aims to make the internet safer for kids by imposing a duty of care on tech platforms to prevent and mitigate certain harms when they implement certain design features, including photo filters and infinite scroll. The bill passed overwhelmingly in the Senate over the summer but has stalled in the House, with the bill’s critics fearing it could be weaponized against disliked speech or lead to a more restricted internet due to platforms’ fears of legal risk.The changes include a clarification that the bill can’t be used to enforce the platforms’ duty of care “based upon the viewpoint of users expressed by or through any speech, expression, or information protected by the First Amendment to the Constitution of the United States.” It also narrows the duty of care with respect to anxiety and depressive disorders to make it enforceable only when those conditions are “objectively verifiable” and linked to “compulsive usage.”Yaccarino previously endorsed the bill on behalf of X earlier this year, while CEOs of companies like Meta and Google have not gone so far, and KOSA supporters point to tech lobbying as a key obstacle. But Republican leadership in the House has also become a hurdle for the bill’s passage. House Speaker Mike Johnson (R-LA) told Punchbowl News in October, “I love the principle, but the details of that are very problematic.” He worried about “unintended consequences.” House Majority Leader Steve Scalise (R-LA) is viewed as potentially even harder to win over, Punchbowl reports, and is concerned about the scope of the duty of care in the bill.

The Windows Forecast is a look at the future of Windows that comments on the latest news for Windows Insiders, as well as other major announcements in the Windows space each and every week. My name is João Carrasqueira, and I've been covering the world of Windows professionally since 2018. If there's something you'd like to see covered, you can reach me at [email protected].

Image: NZXT Gamers Nexus has released a video deconstructing NZXT’s defense of its Flex gaming PC purchase and rental program. In it, host Steve Burke says the company is still misleading customers, despite adjustments made in response to his previous video in which he called the program “a scam.”NZXT said in its response this week that it would clarify details about its Flex program, which Gamers Nexus had criticized for having specs that would change sometimes “day-to-day.” The company has appeared to update specs and performance numbers for its purchase builds. But Gamers Nexus reports it still spotted issues like inconsistent FPS numbers and a FAQ that implied NZXT’s for-sale Player: Three Prime build uses an RTX 4090 graphics card, despite its specs saying otherwise. The FAQ entry Burke mentions seems to be gone now, but as of this writing, there’s still an entry titled “What GPU is right for me?” that lists the RTX 4090 and its benefits. Such inconsistencies are a problem for potential customers, Burke says.The fact that NZXT misrepresented its product, even after its statement, as having a 4090 when it still had a 4080 Super ... seemingly indicates that even NZXT can’t keep up with its own specs changes. If NZXT can’t keep up with it ... how are they expecting the customer to keep up with it?Gamers Nexus offers other criticisms of the company’s rental program, from “improper packaging” damage fees with upper bounds that exceed the cost of equivalent non-rental versions of the PCs to the creator-based ad videos that continue to exist, despite the company saying it had “pulled all influencer-led Flex advertising.” NZXT did not immediately respond to our request for comment on the new video.Gamers Nexus said Thursday that it’s working on a deeper investigation, and its video today ends with Burke saying he’s received “a number of very concerning tips” from former employees and customers.

If you're a big fan of Ubisoft games, you may have had a rough time getting them to run properly on Windows 11 recently. Users reported that the 24H2 update caused a wide range of issues with select Ubisoft games, including a black screen It got so bad that Microsoft delayed Windows 11 24H2 for affected PCs. Well, if your PC didn't get its 24H2 update because of this weird issue, it seems that Ubisoft and Microsoft are finally making progress, and some—but not all—gamers can now get the update.