New UX setting to highlight all input/selection fields in yellow

Is there a setting in the New UX that shows all input/selection fields in yellow regardless of format. I want the users to see grids for inputting text and selecting within drop-down/pick lists in yellow.

Accepted answers

JaredDolich

@jbrown

Great question. You can use conditional formatting but you will need to set up a numeric line item. So, for example, lets say you wanted to highlight an editable line item as you suggest. What you could do is add a line item with the formula = 1. Then when you set up conditional formatting you'll highlight the editable field, turn on conditional formatting, and use the new line item as your filter to determine if the field should be yellow. Here's a screenshot.

Puneeth H P

Hi @jbrown

Adding to @JaredDolich you can always have a line item for CF and you can either hardcode it some value and have Conditional Formatting on basis of that to 'n' number of line items in that module .
Also sometimes on the basis of previous line items (like some actions need to be done by user) ,in this case you can put formula on basis of that action line item (ISNOTBLANK(action line item)) . By this you can avoid CF for the whole column and have CF for only used Row from users .

Please let me know any further things needed here .

Thanks,

Puneeth HP

All comments

JaredDolich

@jbrown

Puneeth H P

Hi @jbrown

Please let me know any further things needed here .

Thanks,

Puneeth HP

jbrown

This is working, we added CF status line items in each module that don't already have. Those modules that already have CF status line items now have ifisblank formula and a large numeric range so we can add the lightest yellow available with some added white to arrive at a light yellow that is consistent with the other grids/modules.

Thank You so much!

Joshua

jbrown

Two points to update on this:

we are attempting to get the colors consistent throughout and having trouble with pre-existing conditional format;
and Field Cards do not allow any Conditional Formatting so we currently cannot have consistent yellow input fields.

Quick Links

Can you help?

Unanswered questions

Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
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.…