find date and colour cell red

[redspanna]

Hi all

Columns E,G,I,K.......AA contain months of year as January-11, February-11...etc

Then rows 10-40..holds the numbers 1-31 (to represent the days)

so the user inputs a date as formatt ddd dd mmm yy, then I want cells E10:AA40 searched for that date and when found colour that cell RED.

so if user inputs Wed 16 Mar 11 into cell A1 the search is done and as a result cell I125 is the cell for Wed 16 Mar 11 so it is coloured RED.

any ideas??
many thanks

 

[Dryver14]

the best way to do this is to have your headings accross the top

ie jan feb mar apr etc

and then put the date in the row beneath ie under jan put 01/01/11 and then pull down for the month so you have all dates then format date special to just d they will only see a single digit then highlight the table and simply put =A1 in the formula