G
Guest
I want to hide other rows that Do NOT have aconditional format.. We have a
VLOOKUP driving the conditional formating. It turns the cells RED. I want
to examine the cells in the rows and hide the rows that do not have the
conditionalformat changed to RED.
I tried but it did not pick uo the color index:
If Cells(x, i).Interior.ColorIndex = 3 then Cells(x,
i).entirerow.hidden=true
The cells.ColorIndex always come back as "-4142". If I format a cell to RED
then it will return a value of 3.
How do i pick the cells that were turned RED via conditional formatting?
OR do I have to mimic the VLOOKUP formula,(could get messy.
Thanks
VLOOKUP driving the conditional formating. It turns the cells RED. I want
to examine the cells in the rows and hide the rows that do not have the
conditionalformat changed to RED.
I tried but it did not pick uo the color index:
If Cells(x, i).Interior.ColorIndex = 3 then Cells(x,
i).entirerow.hidden=true
The cells.ColorIndex always come back as "-4142". If I format a cell to RED
then it will return a value of 3.
How do i pick the cells that were turned RED via conditional formatting?
OR do I have to mimic the VLOOKUP formula,(could get messy.
Thanks