Search code examples
google-sheetstimestampgoogle-sheets-formulaformulaconditional-formatting

Conditional Formatting doesn't recognize timestamp?

i am using a code for timestamp link here.

The issue is when i am trying to condtional format the row base on date i.e today it isnt working =$A1=today() what might be the issue

Conditional Formatting doesn't recognize timestamp?

you can find the sample sheet here link

Solution

  • The dates are calculated as a counting from 30/12/1899. For example, 29/12/2022 is expressed as 44924:

    enter image description here

    The hours, minutes and seconds are expressed as a fraction of a day:

    enter image description here

    So, as suggested you should keep the INT part or ROUNDDOWN the value of the TIMESTAMP in order to match TODAY's date (that is an integer without decimals):

    =INT($A1)=TODAY()
=ROUNDDOWN($A1)=TODAY()