Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 13th 08, 07:38 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
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?

  #2   Report Post  
Old November 13th 08, 07:57 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default Find cells w/background color based on conditional formatting

You would need to have a formula equivalent to the CF criteria in a
helper column, to return, say, Yes or No. Then you can filter that
helper column for all the cells that contain Yes. I'm not sure what
you mean when you say "Find" all the cells.

Hope this helps.

Pete

On Nov 13, 7:38*pm, Freida wrote:
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?


  #3   Report Post  
Old November 17th 08, 07:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 13
Default Find cells w/background color based on conditional formatting

Yes, Pete, I believe that would help.

What I meant by find:
I have a worksheet that highlights date fields that signify that a date
based on certain criteria. For now the user was scrolling through the sheet
to locate all the rows with highlighted dates. I felt it would be better if
she could just use "Find".

Thanks for your help.

Freida

"Pete_UK" wrote:

You would need to have a formula equivalent to the CF criteria in a
helper column, to return, say, Yes or No. Then you can filter that
helper column for all the cells that contain Yes. I'm not sure what
you mean when you say "Find" all the cells.

Hope this helps.

Pete

On Nov 13, 7:38 pm, Freida wrote:
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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Font Color Based on Conditional Formatting tj Excel Worksheet Functions 8 October 11th 08 02:08 AM
Conditional formatting: same color, alternate background on same r Tim Toennies Excel Worksheet Functions 1 June 27th 08 02:05 PM
Change background color using conditional formatting pfa Excel Worksheet Functions 4 August 21st 07 02:56 PM
Change font and background color of several cells based on result of a formula Zenaida Excel Discussion (Misc queries) 2 April 27th 06 06:46 PM
Conditional cell background formatting, based on cell content nosivad Excel Discussion (Misc queries) 5 February 11th 06 11:12 PM


All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017