yogi_Conditional Formatting For Tentative Launch Date When It Precedes A Specified Reference (Today) Date

                                         Google Spreadsheet   Post  #1646
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-23-2014
post by BryanP -- question by sricha: (https://productforums.google.com/forum/#!mydiscussions/docs/OsjqOTXZQl4)
New Conditional Formatting option - Custom formula is
Hello,

Wanted to check if today() function can be used within custom formula of conditional formatting? I am trying this query which otherwise works fine-

=if(F3<TEXT(left(today(),1)/3, "0.0")))

Appreciate any help.

--

thanks

Richa

---

Thanks for looking into it Yogi !

I am trying to highlight a cell based on its current status.

Details-

One cell contains product's tentative launch date. Another cell contains actual launch date.

I need to highlight 1st cell in red when today's date is > 'tentative launch date' and 'actual launch date' is null

---------------------------------------------------------------------------------------------------------------------------------------------