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.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/conditional_formatting_row_with_and_function.mp4′]

 

 

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

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

Submit a Comment

Your email address will not be published. Required fields are marked *

14 − one =