Timed blanking of text

[GerryK]

Hi,
I'm having a bit of a problem (still) trying to white out
some text on a time/date basis.
I would like to do this through conditional format:
=TODAY()>(DATEVALUE("5/19/2004)+TIME(8,45,0))

I can get the conditional format to work on the date but
not the date and time combination.

Any advice?

TIA

 

[Frank Kabel]

Hi
try
=NOW()>(DATEVALUE("5/19/2004)+TIME(8,45,0))

 

[GerryK]

Hi Frank,
That still is not working, the text goes white but
logically should not.
My intention is to format a cell to white text after a
certain date and time has passed.
The formula logic appears correct and I've tried some
rearranging and I'm still baffled.

 

[Frank Kabel]

Hi
try the following
=NOW()>(DATE(2004,5,19)+8.75/24)

does this work for you?

 

[GerryK]

Frank,
That one does work!
Thank you ever so much!