Monday 21 October 2019

What Is Date Occurring In Conditional Formatting?


What Is Date Occurring In Conditional Formatting?


In Conditional Formatting “Date Occurring” is a function which highlights those cells' that contains certain date selected from the given options while applying Date Occurring formula.

Please follow the below images for better understanding.

Click on conditional formatting > Highlight cell rules > Date Occurring.

how to use excel conditional formatting date occurring
excel conditional formatting date occurring

Click on Date Occurring a new window open like below image and you can choose any date from the given option according to your work condition.

excel formula to change cell color based on date
date occurring conditional formatting in excel


No comments:

Post a Comment