Filter For Conditional Format

[Frank Haverkamp]

I have a group of cells that have conditional formatting based on th
answers from another group of cells.

I want to try to filter for cells that have a conditional format tha
been turned on.

If an employee is on vacation his cell for that week changes color. I
he has hours of work scheduled that will be a problem. I'm trying t
filter to see an conflicts without looking at the rows individually.

Thanks in advance

Frank Haverkamp
(e-mail address removed)

 

[DDM]

Frank, Chip Pearson addresses this question on his Website. Look here:
http://www.cpearson.com/excel/CFColors.htm.

 

[Frank Haverkamp]

Thank you for the suggestion, but that link works for sorts and does no
work for results derived from conditional formatting statements.

Any other ideas?

Thanks again

 

[Peo Sjoblom]

Use a filter with the same criteria that you use for the conditional
formatting