Conditional Formatting - Calendar

**efernandes67** · 12-10-2010, 08:55 AM

Hi,

See file in attach.

My calendar days have formulas so I need to create conditional formatting rules that show me the events listed in the table.

In cells D16 and D18, you can see that my formula works fine, but now I need to put in condtionional formatting rule.

I created A rule on Cell D8 but it is not working. What am I doing wrong?

The example is simple but its not very easy to explain in words, so get a look at the file .

Regards,
Elio Fernandes

**NBVC** · 12-10-2010, 09:10 AM

2 things...

- conditional formatting does not accept CSE array formulas...
- it seems it also doesn't like using the table references...

But if you refer them to indirectly with INDIRECT() it seems to work fine....

so try:

=INDEX(INDIRECT("tbPlanner[Type]");MATCH(1;INDEX((INDIRECT("tbPlanner[Name]")=Name)*(INDIRECT("tbPlanner[Start Date]")<=H8)*(INDIRECT("tbPlanner[Start Date]")>=H8);0);0))="Fr"

**efernandes67** · 12-10-2010, 10:02 AM

Thanks it's working.

Regads,
Elio fernandes

**efernandes67** · 12-10-2010, 10:20 AM

Hi,

I used your formula and its working ok, but when I changed the "applies to:" $C$6:$I$11, I was expecting that day 12 and 13 would get "Blue" as day 11 and 16,17 and 18 would get "Green" as day 15. What seems to be the problem?

Regards,
Elio Fernandes