using COUNTIF for cells that are coloured

S

simonfothers

Needing to produce a formula that counts cells that provide a result that is
0 but <3, AND also only those that are shaded Orange in addition to the
Click to expand...
values.

Is there a way to count cells based on data as well as formatting, in this
case, cells that are coloured ?

thanks !
 

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

Using <= in countifs statement 1
Calculations based on cell colour 9
Can you regonise a coloured cell in a formula? 2
Search cell value in same column 3
Conditional Formatting - Excel 2003 2
Coloured Cells 8
Counting Cell Background Colours 18
Cell Colour Pallett Changing........... 0

Top