If Stmt using background color to evaluate

[Maureen]

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.

 

[Maureen]

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

 

[Fred Smith]

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

Regards,
Fred.