Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format: looking for formated
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format: looking for formated
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format: looking for formated
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format: looking for formated
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" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Colored Cells that are Conditional Formated | Excel Discussion (Misc queries) | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Copying a format that has been conditionally formated | Excel Discussion (Misc queries) | |||
% Formated cells randomly changing to hh:mm:ss format | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |