Conditional formatting

[efernandes67]

Hi,
I have this code working in excel conditional formatting rule:

=AND(MOD(WEEKDAY(E$11);7)>=2;IsHoliday(E$11)=FALSE)

IsHoliday is a UDF function that checks if the date is an holiday.

I need to create this code to write the conditional formatting rule in VBA.
Any ideas?

Regards,
Elio Fernande

 

[Tom Urtis]

Any ideas?

One idea is, have you tried to record a macro to do this? If so, what was the result.

 

[efernandes67]

I have excel 2007 and I already tried to record a macro and I get an empty macro!

Any more ideas?