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.

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.

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.

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.