| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chosing cells with a specific colour and taking average value from
Hi,
I have cells with different colours. I want to go through a column and look for the max.value of red cells, the average of red cells and the median of red cells. S So I want to ignore cells with other colours and just use cells with a specific colour. Can somebody help me with this? I'm very new at this, have tried for a while now, but it's not working.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| taking an average of every 30 cells | Excel Discussion (Misc queries) | |||
| Colour cells of specific value? | Excel Discussion (Misc queries) | |||
| How can I count cells of a specific colour (pattern)? | Excel Worksheet Functions | |||
| Counting cells with a specific background colour | Excel Discussion (Misc queries) | |||
Threaded Mode
