I applied Conditional Formatting to a row based on a cell value in the same row. The hope was that I could hide the column to which the conditional formatting was applied and the conditional formatting for the row would remain in place. The color of the entire row would indicate to what category the row belonged. This gives more room for data in other cells to fit nicely on the table.
Unfortunately, when I hid the column, the conditional formatting also disappeared.