Cell colouring

[oggy3000]

Hello,
I want to color a certain area/number of cells if one certain cell contains the current date. Lets say B40 contains todays date then I want cells B 42-51 to be coloured in blue. If C40 contains the current date, cells C 42-51 are to be coloured blue and so on. The Problem for me is, that data for each month is below the other one. So October goes from lines 40-51, November from 52-63 etc.
Is there any way (VBA or conditional formatting) to achieve this kind of colouring rule?

Thank you

 

[Jerry Sullivan]

Hi,
If you have a label designating each group of 10 rows for each month, then you could use a single Conditional Formatting rule relative to that label.

This will need to be tweeked to fit your worksheet, but hopefully it will give you the idea.

Excel Workbook
	A	B	C	D
40		10/17/2011	11/15/2011
41
42	October
43
44
45
46
47
48
49
50
51
52
53
54	November
55
56
57
58
59
60
61
62
63
64
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B42	1. / Formula is =AND(ROW()-MATCH(TEXT(A$40,"mmmm"),$A$1:$A$200,0)<10,ROW()-MATCH(TEXT(A$40,"mmmm"),$A$1:$A$200,0)>=0)	Abc

 

[oggy3000]

Thank you very much