B1 9/1/06    C1 BLANK
B2 3/2/06    C2 BLANK
B3 5/2/06    C3 BLANK
B4 6/15/06   C4 BLANK
B5 7/15/06   C5 BLANK

How do I create a hyperlink (same workbook/sheet)that will highlight boxes
in column C that are after today's date.

---

Request for Question Clarification by cynthia-ga on 10 May 2006 18:38 PDT

Read this page and tell me if it helps:

Conditionally Formatting for Multiple Date Comparisons
http://exceltips.vitalnews.com/Pages/T1155_Conditionally_Formatting_for_Multiple_Date_Comparisons.html

Based on this page, changing the instructions for your question, this should work:

1) Select the range of dates to which you want the conditional format applied. 

2) Choose Conditional Formatting from the Format menu. Excel displays
the Conditional Formatting dialog box.

3) Change the second drop-down list from "between" to "greater than." 

4) In the third control enter TODAY().
 
5) Click Format, click the PATTERNS tab, change the cell shading to
whatever highlighting color you want, then close the Format Cells
dialog box.

6) Click ENTER.

---

Clarification of Question by pachyderm-ga on 15 May 2006 07:32 PDT

Thank you Cynthia & binhcando-ga.

Hi there,

cynthia-ga gave a very good refernce, but still need some adjustment.
I checked this myself, here are some fixes:
1. In step 1, in order for this method to work, you need select the
range of the cells that contain the conditional value. In this case,
the column B.
2. In step 4, you should type =TODAY(), if you type TODAY() it will
become ="TODAY()" and hence won't work.

I know it's not pachyderm-ga exact expectation but I suggest it is
very good method. With this solution, you won't need to click on the
hyperlink to highlight the empty boxes on column C. Instead, it will
automatically highlight the cells on column B that are after today.

Goodluck,
binhcando-ga - future researcher

Thanks for the correction. I didn't think it was perfect, and I'm glad
you came along to correct me!

Hi pachyderm,

Type the following command in the respective cells.
Cell  Formula in the cell
====  ===================
C1   =IF(B1>TODAY(),HYPERLINK("://www.google.com", "click here"),"BLANK")
C2   =IF(B2>TODAY(),HYPERLINK("://www.google.com", "click here"),"BLANK")
C3   =IF(B3>TODAY(),HYPERLINK("://www.google.com", "click here"),"BLANK")
C4   =IF(B4>TODAY(),HYPERLINK("://www.google.com", "click here"),"BLANK")
C5   =IF(B5>TODAY(),HYPERLINK("://www.google.com", "click here"),"BLANK")

This is what you want ?

Regards/RajaCSekar