Conditional formatting or ...??

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 364

Conditional formatting or ...??

Hi Brian,

Something like this should do what you want:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
If IsDate(Target.Value) Then Target.EntireRow.Hidden = True
End If
End Sub

Regards,
GS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting cells in a column with conditional formatting?	shamor	Excel Discussion (Misc queries)	8	May 19th 08 10:11 PM
Protect Cell Formatting including Conditional Formatting	Mick Jennings	Excel Discussion (Misc queries)	5	November 13th 07 05:32 PM
conditional Formatting based on cell formatting	Totom	Excel Worksheet Functions	3	January 20th 07 02:02 PM
conditional Formatting based on cell formatting	Totom	Excel Worksheet Functions	0	January 15th 07 04:35 PM
Conditional Formatting that will display conditional data	BrainFart	Excel Worksheet Functions	1	September 13th 05 05:45 PM

All times are GMT +1. The time now is 12:29 PM.

Menu

About Us