Forum Discussion
Excel labs: internal error while processing the request on Mac
Hello to all, I was working on a new file on Mac testing conditional formatting - I was using Excel Labs to edit formulas without any issues. As the conditional formatting didn't work as expected...
nkal24 Please share the formula so that we can at least have a look. Even better if you could share a file with the CF formula in it (OneDrive, Dropbox or similar). One that works on a PC but not on your Mac.
- Thanks - I haven't figured out how to share a file anonymously. I'll do it later today.
- Hi @ Riny_van_Eekelen, I have added a link to the file - please let me know if you have trouble opening it. It 's the first time I'm sharing a file in this manner.
Thank you very much for looking into this.
After updating it in Name Manager, it got automatically changed to the following (as expected):
=OR(MAP(TOCOL(dates_to_highlight, 1), LAMBDA(range, AND(MONTH(Sheet1!E5) = MONTH(TODAY()), DAY(Sheet1!E5) >= --TEXTBEFORE(range, "-", , , , range), DAY(Sheet1!E5) <= --TEXTAFTER(range, "-", , , , range)))))`But the conditional formatting still fails on Mac but works under Windows.
nkal24 Can open your file without issues on a Mac. Though I don't really understand you conditional formatting set-up.
- First of all thank you for looking into this.
The opens fine under Mac, the problem is I cannot edit formulas in Excel Labs as before since I made some changes under Windows.
I did not at all explain the purpose of the conditional formatting: it basically highlight cells in the 'calendar' range for the ranges and dates specified in the 'dates_to_highlight' range.
