Highlighting Particular Cells in the grid

You can specify that particular cells in the grid are to be highlighted.

This is done with the Highlight Cells window. This can be invoked by View > Highlight Cells or click on the Layout button and select Highlight Cells.

v10CellConditions

On the Highlight Cell window you specify a series of conditions and, when matched, the highlight color of the cell.

in Column, select a column name from the dropdown list
in Operator, select a comparison operator from the dropdown list
in Value, enter the comparison value. Note that this is case independent.
in Color, left-click to specify the nackground-color of the cell. Right-click to select the foreground color.

If you select Only show rows that meet a condition, only the rows that meet one of the conditions will be shown in the grid. The other rows will be hidden.

Click on Apply to apply the hightlight conditions to the grid, and keep the Highlight Cells window open.

Click on Close to apply the hightlight conditions to the grid, and close the Highlight Cells window.

Highlighting is Saved with the Layout

When you save the layout of the table, the Highlight Cell conditions are saved with the layout.

When you apply the layout, the Highlight Conditions are reapplied to the display.

Advanced Query Tool

https://www.querytool.com