| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula "do if red": Possible?
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) ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula "do if red": Possible?
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) ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula "do if red": Possible?
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) ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula "do if red": Possible?
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) ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula "do if red": Possible?
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) ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula "do if red": Possible?
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 "fak119" wrote: 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) ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
