jonep Posted February 3, 2011 Share Posted February 3, 2011 We are creating a layout to display in table view the status of an order. We are giving it the ability to show either open orders or all orders. When viewing all orders we would like to use conditional formatting to change the background colour of the completed order rows to a different colour (say red). How would I go about this (if its even possible)? Link to comment Share on other sites More sharing options...
bcooney Posted February 3, 2011 Share Posted February 3, 2011 You cannot format a row (as you can in list view), but you could use cf to format each cell's background. Completed orders red? Red, to me, calls attention to the item. I'd actually want to fade the completed order away, and so I'd fill or change the OrderID text to a gray. Open Orders could be filled yellow. Link to comment Share on other sites More sharing options...
jonep Posted February 3, 2011 Author Share Posted February 3, 2011 Agreed about red, was an example colour (first to come to mind). How do I conditionally format the fields with a formula outside of its own field (ie set field name to colour=grey WHERE field id=12). I only seem to be able to set it for the field in question. Link to comment Share on other sites More sharing options...
bcooney Posted February 3, 2011 Share Posted February 3, 2011 I can't link to FM Help anymore, apparently, but follow this path using FM Help: Home > Designing and creating databases > Editing objects on layouts > Selecting and working with objects on a layout > Defining conditional formatting for layout objects Link to comment Share on other sites More sharing options...
jonep Posted February 3, 2011 Author Share Posted February 3, 2011 Perfect thank you. I was only looking at Value is, I now know to look at Formula is... All sorted. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4802 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now