Will SRAM RED eTap work with a 36 or 42 tooth cassette?

No. The maximum cassette size compatible with the short cage eTap rear derailleur is 11-28. The eTap WiFLi rear derailleur can accommodate up to an 11-32 cassette.