View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freida Freida is offline
external usenet poster
 
Posts: 13
Default Find cells w/background color based on conditional formatting

My worksheet has cells that are highlighted, or not, based on conditional
formatting. Is there a way to use "Find" to find all the highlighted cells?

I know I can use Find to find all cells with a specific background color,
but it doesn't seem to work here where the color is determined by conditional
formatting. Is there a way to do this?