hightlighting row with the current date

[sanlen]

Hi,

I am trying to hightlight the row which my the sum of other two columns equal to the current date.
I am thinking to go with this way:

if the week start plus day of the week equal to current date (=$A$2:$A2+$C2-1=TODAY()) then i would like to use conditional formatting to highlight my row.
However, it looks like i cannot work it out. I have attached a file as the reference.

Please kindly advice, and your comments will be very much appreciated.

[jwright650]

I don't think Excel realizes that you have a date so it is comparing today's date to a number(formatted as general).

[NBVC]

Select columns D and E and apply conditional formatting formula (Home|Conditonal Formatting|New Rule >> use formula to determine which cells to format):

=LOOKUP(9.99999E+307,$A$1:$A1)+$C1-1=TODAY()

Click Format and choose colour.