View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default conditional formatting when entering a date

One more on this topic. How do I take a number like (97.5) and convert this
to time (97:30)

Thanks

"tongon" wrote:

I have reviewed a number of posts on conditional formatting, but have not
found my answer yet. Here's my problem:
I am attempting to shade a row after a date is entered in a specific cell.
Essentially, I want the row shaded whenever anything is entered in the
specific cell.
I appreciate any help.

Thank you

Tony