Hi community,
I want to give a colour background for my input cells in new UX. Just wondering if there is a straight forward option.
Any advises will be appreciated.
Thanks
Kal
@logikalyan for input cells we cannot format the cells background instead you can just format the templates.
Hi SriNitya,
Thanks for your response.
Can you please elaborate how we can format the cell templates so that input cells will have a background colour?
Regards
Think the simplest way (albeit potentially time consuming) would be to have conditional formatting assigned to the relevant line items so that it's a colour if 0, false, blank and then another (probably nothing) when it's been filled in.
You'd likely need to create specific conditional formatting line items which are 1 or 0 to do this.
Thanks Andrew,
Yes this can be done using conditional formatting on line item. But we have to do this an every UX page right?
Is there anyway we can do this in the backend view and UX will take that logic.
Br
That's correct. There's probably an idea on the idea exchange where someone has already suggested being able to have a different set of colouring for input cells.
Thanks Andrew
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…