Conditional Formating

[Steve]

Does anyone know of a way to conditional format a row to
hide if a certain value appears in a cell?

 

[John Wilson]

Steve,

Conditional formatting to hide a row??
No.
(maybe to set the font color to white to hide the
values, but not the rows)

Try an Advanced Filter
http://www.contextures.com/xladvfilter01.html

John

 

[Frank Kabel]

Hi Steve

for this you need VBA. Though before you try this, maybe two other
suggestions
1. Set the conditional format to 'WHITE'
2. Use autofilter to display all values except your specific value

If this does not help you, you have to process the Worksheet_change
event:

Private Sub Worksheet_Change(ByVal Target As Range)
Set SourceCell = Range("A1")
ConditionValue = "your string expression"
If SourceCell = ConditionValue Then
Range("B1").EntireColumn.Hidden = True
Else
Range("B1").EntireColumn.Hidden = False
End If
End Sub

Frank