fbpx

EXCEL CONDITIONAL FORMATTING WITH FORMULA

by | Aug 20, 2012 | Case Studies - How To | 2 comments

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.

 

 

As always, there is a file for you to practise on. 

Be Sociable, Share!
  • Twitter
  • Facebook
  • email
  • StumbleUpon
  • Delicious
  • Google Reader
  • LinkedIn
  • BlinkList

2 Comments

  1. Name (required)
    Name (required) on June 19, 2017 at 9:27 pm

    This was useful, I will now practice.

    Reply
    • admin
      admin on June 29, 2017 at 8:56 am

      hi Anne, delighted to hear you found it useful. Let me know how you get on.

      Reply

Leave a Reply to Name (required) Cancel reply

Your email address will not be published.