Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Conditional Formatting a la Excel?

coldspring
in Calculation Engine (Define Fields)

Featured Replies

I need to have a field (text and background) formatted based on the condition in the cell. For example if the value in the cell is greater than "x", the text should turn blue, if the value in the cell is less than "y" the text should turn red.

Any help is much appreciated.

I would recommend visiting John Mark Osborne's website www.databasepros.com, click on the Resources link and do a search for Colored Fields. John has an example file that you can download.

HTH, Mike

If you download my Handy Bits file (RussCalcs From Oz) in the Samples section of this forum - go to the bottom and get the latest file (v2), there are examples of both conditional coloured text and coloured backgrounds.

Create an account or sign in to comment

https://fmforums.com/topic/13443-conditional-formatting-a-la-excel/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.