ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas (https://www.excelbanter.com/excel-worksheet-functions/164009-formulas.html)

Plan Room Queen

Formulas
 
Can I create a formula that only counts cells that have been shaded or
colored? For example, every week I run a report that lists all active
"requests for information". The report shows the date the request was
created. Can I color the ones created since the last report, and create a
formula to count only those cells with the color?

JE McGimpsey

Formulas
 
See

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

In article ,
Plan Room Queen <Plan Room wrote:

Can I create a formula that only counts cells that have been shaded or
colored? For example, every week I run a report that lists all active
"requests for information". The report shows the date the request was
created. Can I color the ones created since the last report, and create a
formula to count only those cells with the color?



All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com