Find Highlighted Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have searched in all the discussions but was unable to find out if excel
can find highlighted cells.
Lets say I have a worksheet that has certain cells highlighted based off a
formula. On a seperate worksheet I want some type of If statement, such as
=If('Wkst1'!B9="yellow highlight","Y","N")
Is this possible?
 
If the cells are highlighted using Conditional Formatting you can find them by
stipulating the same criteria in your formula.

If the cells are highlighted manually you must use a User Defined Function.

See Chip Pearson's site for finding colored cells.

http://www.cpearson.com/excel/colors.htm

Read Chip's notes on event changes and also the caveat regarding finding cells
colored by Conditional Formatting.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to highlight cells in special order 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Creating a formula to highlight a row of cells 3
Highlight MAX Cell Greater Than Zero 4
how to count number of highlighted cells in column 5
Excel JUMP FROM SEARCH BAR TO RESULT 3
Find utility, highlighting answer 2
Word Globally Changing Specific Color Highlight to Background Color 0

Back
Top