=IF (cell color) then?

**stevemyers** · 03-18-2010, 02:42 PM

Two part question:

1. How do I structure an IF statement based on a specific cell color (e.g. if a cell is yellow, then perform function x)

2. How do I know what color is what? Is there a pantone reference? A color "name" that excel uses?

Thanks

**martindwilson** · 03-18-2010, 07:25 PM

why is the cell coloured?
you can use conditional format to colour the cell then use the same criteria in a function

**stevemyers** · 03-19-2010, 01:48 PM

The cells are not conditionally formatted...it is a manual process based on non-conditional input.

**Palmetto** · 03-19-2010, 06:25 PM

Excel does not have a built in function to determine cell color. You would need to use VBA code to determine cell color.

If you can use a VBA solution, search the Forum using terms like: Count cells by color, or Sum cells by color, etc.

To martin's point, what logic are you using to determine cell color? If the fill color selection is a random process (no logic or consistency), then it will be a bit difficult to determine which cells to reference in any formula.

Sum/Count Cells By Fill Or Background Color in Excel

**oldchippy** · 03-19-2010, 06:28 PM

Hi,

This might help?

http://excel.tips.net/Pages/T001978_..._of_Cells.html

**krichmond0306** · 06-17-2011, 09:56 AM

I could use help with this also, to be specific, I am taking data and assigning it a confidence level. The confidence level is going to be indicated by the use of cell background color, ie a green cell indicates a +/- 10% confidence level and therefore my expected data rande is X+(X*.1) and X-(X*.1) and so on (X being my measured sampled.

How do I create function so that IF the cell is one it uses one confidence level, if its another then a different one, etc?