tammyl
02-21-2010, 10:37 PM
Hi,
I'm trying to conditionally format a calendar cell (background colour) based on criteria from two columns.
Date, Type
1/1/10, 1
1/1/10, B
6/1/,10, B
10/1/10, B
20/1/10, A
1 = Holiday
B = Birthday
A = Anniversay
January 2010MTuWThFSaSu 12345678910111213141516171819202122232425262728293031
H11, being the first cell in the calendar.
I've tried the following but can't get the reference to work for my 'Type' column. The following formula colours the background if the calendar cell date is within the Dates named range.
=MATCH(H11,HList_Dates,0)
Basically, i want it to colour the background if
If Type =B and calendar cell date = Date then colour cell - Pink
If Type = A and calendar cell date = Date then colour cell - Purple
If Type = 1 and calendar cell date = Date then colour cell - Blue
Hope someone can assist.
Thanks tammyl
I'm trying to conditionally format a calendar cell (background colour) based on criteria from two columns.
Date, Type
1/1/10, 1
1/1/10, B
6/1/,10, B
10/1/10, B
20/1/10, A
1 = Holiday
B = Birthday
A = Anniversay
January 2010MTuWThFSaSu 12345678910111213141516171819202122232425262728293031
H11, being the first cell in the calendar.
I've tried the following but can't get the reference to work for my 'Type' column. The following formula colours the background if the calendar cell date is within the Dates named range.
=MATCH(H11,HList_Dates,0)
Basically, i want it to colour the background if
If Type =B and calendar cell date = Date then colour cell - Pink
If Type = A and calendar cell date = Date then colour cell - Purple
If Type = 1 and calendar cell date = Date then colour cell - Blue
Hope someone can assist.
Thanks tammyl