I've used conditional formatting before (e.g., if cell value = X then green; if cell value = Y then red).
Instead, in this case, based on a cell value, I would like to "hide" (meaning white background, white font color, no borders, etc.) a record from displaying in the XLS.
Some of record's column, however, already have conditional formatting applied... so it somehow needs to be "overwritten".
All details are included in the attached XLS.
Does anyone know how to accomplish this (in Excel 2003).