Biden administration announces conditional $700 million loan for Nevada lithium mine
What could become only the second lithium mine in the US received backing from the Biden administration this week. In an spotted by , the Department of…
Browsing Tag
conditional
How to add conditional formatting to a Google Sheets drop-down list (and why you should)
Select the cell that contains the drop-down and then click Format > Conditional formatting. Conditional Formatting is found in the Formatting menu…
How to add a conditional font format using Replace in Microsoft Word
Complex updates don't have to be difficult if you use Replace in Microsoft Word.
Image: PixieMe/Adobe Stock
Microsoft Word’s Replace…
How to add visual insight to data by applying conditional formatting to a table or matrix…
Image: Luca Lorenzelli/Adobe Stock
Designers often use table and matrix visualizations when summarizing numeric data because they’re effective.…
How to add conditional formatting a Microsoft Excel PivotTable without expressions
You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.
Image: Diego/Adobe Stock…
How to add conditional formatting to a Google Sheets drop-down list
Figure 5Select green and the background color will change to green. Image: Jack WallenAnd that, my fellow Google Sheets users, is how…
How to use conditional formatting to highlight rank in Microsoft Excel
Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with…
How to calculate conditional rank in Excel
A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel…
How to add a conditional format that highlights groups in Excel
Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.…
How to calculate a conditional running total using a PivotTable in Excel
At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins…