Blogs about: Conditional Formatting
Featured Blog
MrExcel At The ModelOff Championships – “Multiple Criteria Testing”: Podcast #1614
Bill ’MrExcel’ Jelen: [Almost] Live From New York City to judge the ModelOff Worldwide Excel Championship! With 16 Excel Rock Stars, from around the Globe, in NYC – and Bill having access to the… more →
Learn Excel from MrExcel
Exploiting Advanced Conditional Formatting Concepts - Part I
wrote 2 weeks ago: Conditional Formatting is an extremely powerful feature in Excel 2007 and above that can be used not … more →
Highlighting cells containing an asterisk * in Excel - Pearson correlations in SPSS
wrote 2 weeks ago: Just a quick note as I took a while to figure this out and hopefully it will help. When you have a c … more →
Excel - Highlight Data with Data Validation and Conditional Formatting
wrote 1 month ago: When working with lists of information it is sometimes nice to be able to highlight rows of related … more →
Nutella "Spread"sheet Analysis
wrote 1 month ago: Source: bonappetite.com Nutella has recently been a prime target of thefts – from the undergra … more →
Explorer Preferences
wrote 1 month ago: MC includes a number of preferences that allow you to tailor the display and behavior of records sho … more →
Create an arrow chart
— 1 comment
wrote 1 month ago: I’ve already posted how to make a bridge / waterfall graph where you can show with up and down … more →
Conditional Formatting of List View: Format When Created Date is within the last 3 days
wrote 2 months ago: If you’re formatting a row of a list view, this would go in the advanced formula box when you … more →
Create charts with conditional formatting
— 1 comment
wrote 2 months ago: Sometime last week, I posted a blog regarding how to make your charts look amazing. Afterwards a co … more →
How to create a Bullet graph using excel charts and within an excel cell
— 1 comment
wrote 3 months ago: Bullet graphs were invented by Stephen Few to improve upon standard bar charts and gauges. Instead … more →
Can you use cell formats in excel formula?
— 1 comment
wrote 3 months ago: I’m a big fan of conditional formatting in Excel. The visual display of colour helps me to qu … more →
Add a scroll bar to a data table (and other features)
— 7 comments
wrote 3 months ago: Imagine you have a table of monthly results. Imagine that this table is really large and that it … more →
Dates With Relative Countdowns and Pretty Colors in List Views
— 2 comments
wrote 3 months ago: Applies To: SharePoint 2010 Every list in SharePoint automatically comes with two date columns (Crea … more →
Showing Icons in a List View
— 1 comment
wrote 3 months ago: Applies To: SharePoint 2010 Displaying icons in a list view is a great way to make things immediatel … more →
How to format dates that are over 1 year old to turn red in Excel using conditional formatting.
wrote 3 months ago: Let’s say I have an Excel spreadsheet that has a list of team member names and their last trai … more →
Definitions of spreadsheet jargon
wrote 3 months ago: Spreadsheet- A spreadsheet is an interactive computer application program for organization and analy … more →
Excel - Editing & Customising Conditional Format Rules
wrote 4 months ago: Now that you know how to create rules that can be applied directly to cell values and rules based on … more →
Excel - conditional Formatting: Using Formulas to Apply Rules
wrote 4 months ago: In the previous blog I showed you how to use the basics of CONDITIONAL FORMATTING to automatically c … more →
Excel - Conditional Formatting: Applying Rules Directly to Cells
wrote 4 months ago: You have a spreadsheet full of data that is regularly, if not continuously being updated and rather … more →
Conditional Formatting
wrote 4 months ago: Memformat Cell sangatlah membantu. Misalnya saja, kita ingin cell yang efisiensi diatas 90% berwarna … more →
