Conditional Formatting and Vlookup??

[aishasaccount]

Hi there!

I have a large spreadsheet and I managed to use conditional formatting to make certain rows (when a cell in column G had a value > 1000) turn red.
That caused me to have a large spreadsheet with certain rows red; however, is there a way to use vlookup or any other lookup function to create a LIST of the red rows; more specifically only one column of the red rows?

I'm not sure I explained that very well, but hopefully someone can help!
If you need more details, let me know!

Thanks!!

 

[Mick Peters]

Hi Aishasaccount
I am not proficient in all things Excel but I get by. I attach the below code that I received off someone on this site that hides rows that meet a certain criteria. I use this from a button on a user form but could be a macro. Set up a cell that dose the same as your conditional format but results in a 1 if false and 0 if true. Then have this code look at that column. (Replace the ("G:G") with the column where your cells sit. once activated all the false rows will be hidden. You can do a simple macro to unhide all using the Macro recorder.
I hope this helps
Mick.

Private Sub CmdHide_Click()
'Sub HideRows()
 Dim cell As Range
 For Each cell In Range("G:G")
 If UCase(cell.Value) = 1 Then
 cell.EntireRow.Hidden = True
 End If
 Next
 End Sub