ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sumif - I wish to add cells based on the font/fill colour (https://www.excelbanter.com/excel-worksheet-functions/183497-sumif-i-wish-add-cells-based-font-fill-colour.html)

Pev

sumif - I wish to add cells based on the font/fill colour
 
Is it possible to add cells in Excel based on the fill or font colour? Or is
it possible to add an adjacent cell to a cell meeting a certain criteria?

Pete_UK

sumif - I wish to add cells based on the font/fill colour
 
Check out this page on Chip Pearson's site:

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

Hope this helps.

Pete

On Apr 12, 8:33*am, Pev wrote:
Is it possible to add cells in Excel based on the fill or font colour? Or is
it possible to add an adjacent cell to a cell meeting a certain criteria?



Pev

sumif - I wish to add cells based on the font/fill colour
 
Thanks for your help. That was an interesting link

"Pete_UK" wrote:

Check out this page on Chip Pearson's site:

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

Hope this helps.

Pete

On Apr 12, 8:33 am, Pev wrote:
Is it possible to add cells in Excel based on the fill or font colour? Or is
it possible to add an adjacent cell to a cell meeting a certain criteria?




Pete_UK

sumif - I wish to add cells based on the font/fill colour
 
You're welcome.

Pete

On Apr 12, 5:30*pm, Pev wrote:
Thanks for your help. That was an interesting link



"Pete_UK" wrote:



All times are GMT +1. The time now is 08:59 PM.

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