Conditional Formatting Example with Formula

Dear Friends,

Today I have introduced a great example of Conditional Formatting.

In my example, I have taken two Column, one of which has a date and the availability of items in the 2nd column. I want to search and format the date row and availability row that comes just after today's date and its availability is 0.

1. Open Microsoft Excel.
2. The header in Column A is Date and column B is Availability and fill the data

3. Enter Current Date in E2.
4. Now, Select the data A2 to B18, Click the Conditional Formatting in HOME TAB.
     Click on New Rule.

New Formatting Rule dialogue box will appear, click "Use a formula to determine which cells to format" and Paste the formula         

          =AND($A2=MIN(IF($A$2:$A$18>=$E$2,IF($B$2:$B$18=0,$A$2:$A$18))),$A2<>"")

       in the "Format values where this formula is true" box
.

5. Click on Format button. Click on fill tab and select the color and click on OK.

Here is result output Screen (I have chosen blue color).

You can change the Current date manually and formatting will change automatically.