Conditional Formatting

Question

Is there any way to set each column in a row with an independent conditional format. I have a table that each row is a half hour interval snapshot that shows an number that can be negative or positive, with each column as a day. I want the intervals (row) for the specific day (column) that are negative to show in red for that number in that row/column.

This example for the 9:00 am row, only the Current-Mon and Current-Sat would be in red the others would be unchanged.

------------------------------
Kent Orourke
------------------------------

MarkShnierYou · Answer

Quickbase does not have simple conditional formatting like Excel does. You will need to create a duplicate field for each field that you want to appear with formatting. This will only work on a Table report type and not a summary report type. You do appear to be using a Table report, but then if you are showing text field on the report (the formatted fields would be Rich Text field types). you would lose any totals.

Is it OK to lose all totals?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community