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

The easiest is to check the same condition the conditional format is
checking. (which is what I assume you mean by mimic the vlookup).

Chip Pearson shows how to do this without knowing beforehand what that
condition is.
http://www.cpearson.com/excel/CFColors.htm

--
Regards,
Tom Ogilvy


"Candyman" <(E-Mail Removed)> wrote in message
news:EFAC782F-A2FE-46BD-B45B-(E-Mail Removed)...
>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
>
>
>
>

A Lot of good stuff, but I can not get the results on the VLOOKUP conditional
formula.

There is only one condition.

I am using :


Set FC = Cells(x, i).FormatConditions(1)
Formula_1 = (FC.Formula1)
Result = Application.Evaluate(FC.Formula1)



The code works for some formaulas:
=ISNA(MATCH($A22,I:I,FALSE))

The code jams on the last line for a lookup statement that compares two
lists and highlights changed cells:
=D22 <> VLOOKUP($A22,PreviousReviews,COLUMN(D22),FALSE)

Any ideas?

"Tom Ogilvy" wrote:

> The easiest is to check the same condition the conditional format is
> checking. (which is what I assume you mean by mimic the vlookup).
>
> Chip Pearson shows how to do this without knowing beforehand what that
> condition is.
> http://www.cpearson.com/excel/CFColors.htm
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Candyman" <(E-Mail Removed)> wrote in message
> news:EFAC782F-A2FE-46BD-B45B-(E-Mail Removed)...
> >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
> >
> >
> >
> >
>
>
>

I suspect the problem is that you are not using absolute references in your
formula, so it probably isn't what you think it is.

> Set FC = Cells(x, i).FormatConditions(1)
> Formula_1 = (FC.Formula1)
msgbox Formula_1
> Result = Application.Evaluate(FC.Formula1)

--
Regards,
Tom Ogilvy



"Candyman" <(E-Mail Removed)> wrote in message
news:6975F251-86EF-4E9E-A0A6-(E-Mail Removed)...
>A Lot of good stuff, but I can not get the results on the VLOOKUP
>conditional
> formula.
>
> There is only one condition.
>
> I am using :
>
>
> Set FC = Cells(x, i).FormatConditions(1)
> Formula_1 = (FC.Formula1)
> Result = Application.Evaluate(FC.Formula1)
>
>
>
> The code works for some formaulas:
> =ISNA(MATCH($A22,I:I,FALSE))
>
> The code jams on the last line for a lookup statement that compares two
> lists and highlights changed cells:
> =D22 <> VLOOKUP($A22,PreviousReviews,COLUMN(D22),FALSE)
>
> Any ideas?
>
> "Tom Ogilvy" wrote:
>
>> The easiest is to check the same condition the conditional format is
>> checking. (which is what I assume you mean by mimic the vlookup).
>>
>> Chip Pearson shows how to do this without knowing beforehand what that
>> condition is.
>> http://www.cpearson.com/excel/CFColors.htm
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "Candyman" <(E-Mail Removed)> wrote in message
>> news:EFAC782F-A2FE-46BD-B45B-(E-Mail Removed)...
>> >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
>> >
>> >
>> >
>> >
>>
>>
>>