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

less than 1 minute read

  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.