Detecting a color

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

Guest

Is there a way I can detect if any cell is a certain color in a range of cells?
 
Duncan

It depends what you want to do, there have been a few questions already
regarding counting or summing the contents of coloured cells and there are
some links. If you type colored cells into the search on this discussion
forum, you might find what you want.
 
I took a look and I see how to count in VB, but more specifically what I am
looking for is a formula to return a TRUE or FALSE if there is a certain
color in a range, color RED.
 
Can I do this as a function in Excel, I believe the link shows ways to do it
in VB. Basically I have a range of cells, and I want to TRUE or FALSE answer
as to whether any of them are RED.
 
You must log in or register to reply here.

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

Error Installing "ADAPTEC EZCD 4.04" 1
Excel VBA 1
Formula to detect color? 9
Excel VBA - Problem with Closing Print Preview 0
How to Color a Cell Based on a Range of Cells with Colors 1
Conditional Format Formula Help 2
Excel Macro to automatically go to the right of the last colored cell 0
Counting cells with conditional formatting 3

Back
Top