Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Excel
I need to add cells together based on their background color or font color.
(I only want to add the cells that are red) How do you do this? I know no Visual Basic so it needs to be in real simple terms. I use Excel 2007. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Excel
If you don't know VB, then you will need us to provide complete,
ready-to-use code for you. In order to do that, you are going to have to let us in on your worksheet's layout... at minimum, we need to know where are the cells you want to add together located at and where do you want their sum to be placed at? -- Rick (MVP - Excel) "Golfer Guy" wrote in message ... I need to add cells together based on their background color or font color. (I only want to add the cells that are red) How do you do this? I know no Visual Basic so it needs to be in real simple terms. I use Excel 2007. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Excel
Thank you for your speedy responce.
The values are in a specific Column (FG) and the cells have been conditional formated. (to produce the background color) As far as the sum, it can be placed at the bottom of the column. Does that answer your questions? "Rick Rothstein" wrote: If you don't know VB, then you will need us to provide complete, ready-to-use code for you. In order to do that, you are going to have to let us in on your worksheet's layout... at minimum, we need to know where are the cells you want to add together located at and where do you want their sum to be placed at? -- Rick (MVP - Excel) "Golfer Guy" wrote in message ... I need to add cells together based on their background color or font color. (I only want to add the cells that are red) How do you do this? I know no Visual Basic so it needs to be in real simple terms. I use Excel 2007. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Excel
Golfer Guy wrote:
Thank you for your speedy responce. The values are in a specific Column (FG) and the cells have been conditional formated. (to produce the background color) As far as the sum, it can be placed at the bottom of the column. If the background color is determined by conditional formatting, it may be possible to use the same conditions to obtain your sum without VB. If you provide some specifics about your worksheet, someone may be able to provide a solution. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Excel
I figured it out. I used the CF in the sumif formula...
Thanks! "Glenn" wrote: Golfer Guy wrote: Thank you for your speedy responce. The values are in a specific Column (FG) and the cells have been conditional formated. (to produce the background color) As far as the sum, it can be placed at the bottom of the column. If the background color is determined by conditional formatting, it may be possible to use the same conditions to obtain your sum without VB. If you provide some specifics about your worksheet, someone may be able to provide a solution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." | Excel Discussion (Misc queries) | |||
Saving Excel 2007 conditional formatting in Excel 2003 format | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |