Filter For Conditional Format

  • Thread starter Frank Haverkamp
  • Start date
F

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
[email protected]
 
F

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
 
P

Peo Sjoblom

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