Color a row of excel based on cell date time value (Today)

1. Select all rows of excel in which you want to apply formula. There must be a date time filed on which you will apply rule. Suppose, column A is date time column and it is started from A2
2. Conditional Formatting -> New Rule -> Use formula to determine which cell to format
3. Write in format value text box:  =$A2=TODAY()
4. Click Format button -> select fill tab -> and select color -> Click Ok
5. Finally click ok in the dialog box to apply.