|
Sumif cells of a certain format
I want to add cells that are all fomatted with the a certain cell color.
|
Sumif cells of a certain format
hi
see this site http://cpearson.com/excel/colors.aspx regards FSt1 "SSS" wrote: I want to add cells that are all fomatted with the a certain cell color. |
Sumif cells of a certain format
How do I install the module mentioned in the site. Its a great site - thanks!
"FSt1" wrote: hi see this site http://cpearson.com/excel/colors.aspx regards FSt1 "SSS" wrote: I want to add cells that are all fomatted with the a certain cell color. |
Sumif cells of a certain format
hi
install them into standard modules. Copy and paste function to end function open the VB editor( Alt+F11). in the project window(far left) click your project(file). in the code window(far right) paste the functions. if the code window is dark gray, you may have to on the menu barinsertmodule. code window should be white. save the file. custom formula should be ready to use. Regards FSt1 "SSS" wrote: How do I install the module mentioned in the site. Its a great site - thanks! "FSt1" wrote: hi see this site http://cpearson.com/excel/colors.aspx regards FSt1 "SSS" wrote: I want to add cells that are all fomatted with the a certain cell color. |
| All times are GMT +1. The time now is 09:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com