Search results

perfect, thank you very much!

If it helps, attached is where I am so far

Hello, I have been pulling my hair for a while with this, so hopefully someone can help. here's my setup: tab "MASTER" Starting in A2 and down, I have a list of unique ID In C2 and down, primary colors In D2 and down, secondary colors In E2 and down, tertiary colors In F2 and down, quaternary...

worked perfect, thank for the fix and taking the time to explain what went wrong! (and glad to know that my formulaes were correct and the fault was on Excel lol!)

@Narayan: yes both have the value if I change their format to say general, both says 0.333333 etc... @Somendra Misra: yes it works. But it doesn't work on mine lol I have a bunch a formulas, maybe that's something causing the problem. It's very weird. It's quite a complex spreadsheet (for me...

Hello, I have a problem with a conditional formatting in a spreadsheet I made for work. In short, it calculate time for a meeting and display the local time based on the timezone of each participant. What I have is this: G7: typical working day start = 08:00:00 formatted as time H11: adjusted...

awesome!!! Many thanks Narayan, works perfect!

update: finally found a website not blocked by my VPN. see link in my first post. Thanks again!

yes I know, sorry again about that, the VPN doesn't even allow dropbbox :-( In row 10, it's the date, formatted to show only the full month name. In row 11 and 12, column E is =E10. Row 11 is formatted to show the day (ddd), row 12 to show the day number (dd). the rest is just the previous...

Hello, I finally registered after using the info on your site for a while. I've been asked to create a vacation calendar for an international team. I downloaded the template you made, but it was too complicated for me to edit, and too complex for our needs. My company's VPN does not allow...