B
Brian
I am using cell color functions from Chip Pearson's page:
http://cpearson.com/excel/colors.htm.
I have a large spreadsheet where column L is a daily total and column H is
the amounts making up the daily totals. Therefore the total of columns H and
L are the same. However, a member of my team has been checking off items in
these columns according to certain criteria, and changing the cells they
have checked into a particular green font. They SHOULD have been doing this
consistently both columns, but I have now found (using Chip's excellent
functions) that the total by value in green in column L is only about half
the total in column H.
I want to identify the places where the analysis has not been done right,
and the most convenient would seem to be to open a new worksheet and use the
formula
=IF(cellcolorindex('£ account'!H20,TRUE)=4,'£ account'!H20,0)
which I would then copy down the sheet for the 16,500 rows which are
involved.
However, this formula gives me the #NAME? error. Does anyone know why?
http://cpearson.com/excel/colors.htm.
I have a large spreadsheet where column L is a daily total and column H is
the amounts making up the daily totals. Therefore the total of columns H and
L are the same. However, a member of my team has been checking off items in
these columns according to certain criteria, and changing the cells they
have checked into a particular green font. They SHOULD have been doing this
consistently both columns, but I have now found (using Chip's excellent
functions) that the total by value in green in column L is only about half
the total in column H.
I want to identify the places where the analysis has not been done right,
and the most convenient would seem to be to open a new worksheet and use the
formula
=IF(cellcolorindex('£ account'!H20,TRUE)=4,'£ account'!H20,0)
which I would then copy down the sheet for the 16,500 rows which are
involved.
However, this formula gives me the #NAME? error. Does anyone know why?