No can do. That's why Chip developed his macro.

Regards,
Fred.

"Maureen" wrote in message
...
I'm hoping to do this just with an IF stmnt in a cell and not having to do
macros or VB code.

"Gary''s Student" wrote:

See:

http://www.cpearson.com/excel/colors.aspx
--
Gary''s Student - gsnu200846


"Maureen" wrote:

Is there a way to do an If statement that will evaluate the background
colour
of a cell?
ie. =If(B8.cell.Interior.colorindex=6, "", B8.cell_value)
I want to highlight certain rows in a worksheet and have a second
worksheet
copy over those values unless the background color of the cell is a
particular color.

I've got an if stmt to filter out blank cells (without this it prints
0)
=IF (+Sheet2!A1="","",+Sheet2!A1)
I want to embed a 2nd IF stmnt in here to evaluate the background color
of
the cell.

Ideally what I want to do is, create a second copy of a worksheet
without
the values highlighted in color and be able to delete the worksheet
with the
colored items for general distribution while the main workbook has
limited
distribution.
ie. 2 worksheets full of data, some of which is confidential. Have a
3rd
worksheet that replicates the data without the confidential
information.
Save the workbook as another name, delete the confidential worksheet
and
distribute.