formula based on format

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

Guest

Is there a way to have a formula that is based on a cell colour or based on
the way a cell is formated? I need it to count the number of occurrences
that this happens.
 
This is new to me. I have copied it into the VB sheet and placed the
following formula in a cell but it only shows #Name. What am I doing wrong.
I did this to both the countbycolor and the return colorindex value functions
and neither work.
 
Thanks it works! And I sure learned a lot today! Thanks again.
James Kendall
 
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

Conditional formatting in Excel 2010 2
Excel VBA 1
using COUNTIF for cells that are coloured 1
Copy Conditional Format by formula containing cell defined name 2
Calculations based on cell colour 6
conditionally formatting colour of cells 2
Conditional formatting 3
Conditional Formating based on Data Validation 3

Back
Top