0

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

Skilz Work
  • 15
  • 4

3 Answers3

0

can you try:

=INT($A1)=today()
rockinfreakshow
  • 15,077
  • 3
  • 12
  • 19
0

try:

=($A1*1<=TODAY()+1)*($A1*1>TODAY()-1)

or:

=INT($A1)=TODAY()

and see: https://stackoverflow.com/a/66201717/5632629

timestamp upon range edit:

=LAMBDA(x; x)(IFERROR(B1:1/0)+NOW())
player0
  • 124,011
  • 12
  • 67
  • 124
0

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()
Martín
  • 7,849
  • 2
  • 3
  • 13
  • how about if i want to highlight week old data, will **=INT($A1)=today()-7** work? – Skilz Work Dec 30 '22 at 11:10
  • If you want to highlight that specific day, you can use that formula. If you want to highlight the whole last week? You can do =AND(INT($A1)>=(TODAY()-7),(INT($A1)<=TODAY()) – Martín Dec 30 '22 at 11:21