The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

EXCEL CONDITIONAL FORMATTING WITH FORMULA

by admin | Aug 20, 2012 | Excel | Conditional Formatting, Excel | Intermediate Lessons

In a previous post, I showed you how to use conditional formatting in Excel to highlight entire rows based on a specified criteria. In this post, I am going to show you how to use the AND function to conditionally format rows based on multiple criteria. Please enable...

EXCEL CONDITIONAL FORMATTING

by admin | Jun 5, 2012 | Excel | Advanced Lessons, Excel | Conditional Formatting

Conditional formatting Conditional formatting in Excel 2007 (and later) allows us to colour cells on a spreadsheet depending on whether or not they meet certain conditions. While it existed to some degree in Excel 2003, it has been seriously beefed up in Excel 2007...

Excel shortcut keys – FREE

Recent Posts

  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management

Like Excel Expert on Facebook

Recent Posts

  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved