Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find colored cells in a worksheet
Hi,
I have a worksheet that has data in cells which has also been color coded. What I would like to do is find a way to search for, say, all of the yellow cells in the worksheets and sum the numbers in those cells. And then, of course, do the same for all of the other colors in the worksheet. I thought I could perhaps use a sumif where the criteria is "if the cell is shaded yellow" but I don't know how to set that criteria up. Does anyone have a way to do this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Find Highlighted Cells | Excel Discussion (Misc queries) | |||
adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |