conditional formatting

[samuel_brierley]

if(reloadtime()=today()

can someone see whats wrong with the above expression/

[rustyfishbones]

you are missing ) at the end

So something like

IF(ReloadTime()=TODAY(),GREEN(),RED())

[Anonymous]

Samuel

reloadtime() returns a datetime, whereas today() returns just a date.

So use :

     if ( date(floor(reloadtime())) =today()  ..................

Which converts reloadtime()  to a pure date.

Best Regards,  Bill Markham

[#4]

reloadTime() return the day AND the time the document was reloaded, and today() return only todays day. You should better use:

Date(Floor(ReloadTime()))=today()

[jpapador]

My guess would be that reloadtime() is a time stamp and Today() is just a date.  Use the date function to get them into the same format.

If(Date(Floor(ReloadTime()), 'M/DD/YYYY') = Date(Floor(Today()), 'M/DD/YYYY'), <Condition Here>)