Hi,

A manual selection , coming from outside the spreadsheet.

On a similar question sombody mentioned a function to be found in

http://www.cpearson.com/excel/colors.htm

where it is says the following:

"Excel does not have any built-in worksheet functions for working with the
colors of cells or fonts. If you want to read or test the color of a cell,
you have to use VBA procedure. This page describes several functions for
counting and summing cells based on the color of the font or background.
All of these functions use the ColorIndex property."

Unfortunately my Excell knowledge is too small to be able to build such a
function.


Thank you anyway for trying to help. For the moment I have to work manually
on that sheet.

Felix



"The Fool on the Hill" wrote:

Hello Fak,

Well I don't know of a formula that recognises colour.

Maybe you would want to add a column (B), in which you add a particular
character or message, which canbe used in the formula.
For instance A45 has colour red, then in B45 you type the word red and then
you could use your formula IF(B45="red";1;2) .

But I am intrigued, what is your criteria to make an amount red?

Kind regards,

Jay

"fak119" wrote:

No, unfortunately not

Felix



"The Fool on the Hill" wrote:

Hey Fak,

Is there a particular reason why the amounts are in red?

Because if the amounts are less than 0, you could use
IF(A45<0;1;2) .

"fak119" wrote:

I have highlighted some amounts in red.

Is there a formula that recognizes the colour of the font, e.g.

IF(A45=red (is in red colour);1;2) ?