Highlighting Todays Data Using Conditional Formatting

[glerwell]

Hi

Can I use conditional formatting to highlight todays data.

I would like the cells containing todays data to be a different colour than the other days in a month. eg. D24:J24

I have posted the data to help somebody help me to acheive my goal.

(12) December 2007.xls
	D	E	F	G	H	I	J
9	DATE	PROFIT	BETS	WINS		PLACES
10	01/12/2007	0.00	0	0	0%	0	0%
11	02/12/2007	0.00	0	0	0%	0	0%
12	03/12/2007	0.60	1	0	0%	0	0%
13	04/12/2007	4.53	5	0	0%	0	0%
14	05/12/2007	0.00	0	0	0%	0	0%
15	06/12/2007	0.00	0	0	0%	0	0%
16	07/12/2007	0.00	0	0	0%	0	0%
17	08/12/2007	5.05	3	2	67%	0	0%
18	09/12/2007	0.00	0	0	0%	0	0%
19	10/12/2007	0.85	5	2	40%	0	0%
20	11/12/2007	0.00	0	0	0%	0	0%
21	12/12/2007	0.00	0	0	0%	0	0%
22	13/12/2007	0.00	0	0	0%	0	0%
23	14/12/2007	4.39	4	0	0%	0	0%
24	15/12/2007	0.58	1	0	0%	0	0%
25	16/12/2007	0.00	0	0	0%	0	0%
26	17/12/2007	0.00	0	0	0%	0	0%
27	18/12/2007	0.00	0	0	0%	0	0%
28	19/12/2007	0.00	0	0	0%	0	0%
29	20/12/2007	0.00	0	0	0%	0	0%
30	21/12/2007	0.00	0	0	0%	0	0%
31	22/12/2007	0.00	0	0	0%	0	0%
32	23/12/2007	0.00	0	0	0%	0	0%
33	24/12/2007	0.00	0	0	0%	0	0%
34	25/12/2007	0.00	0	0	0%	0	0%
35	26/12/2007	0.00	0	0	0%	0	0%
36	27/12/2007	0.00	0	0	0%	0	0%
37	28/12/2007	0.00	0	0	0%	0	0%
38	29/12/2007	0.00	0	0	0%	0	0%
39	30/12/2007	0.00	0	0	0%	0	0%
40	31/12/2007	0.00	0	0	0%	0	0%
FLATSTATS

 

[phiero21]

In Conditional formatting wizard, put the condition (for cell D10):

Formulae is: =$D10=TODAY()

and put the same conditional formatting in all other cells.

 

[glerwell]

works fine, cheers mate