Formula "do if red": Possible?

F

fak119

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) ?
 
T

The Fool on the Hill

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) .
 
F

fak119

No, unfortunately not

Felix



The Fool on the Hill said:
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) .
Click to expand...
 
T

The Fool on the Hill

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
 
F

fak119

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
 
T

The Fool on the Hill

Hello Fak,

Well unfortunately I am not familiar with VBA functions. Maybe someone else
can help you or, you could use my work around !

Kind regards,

Jay
 
Top