Sharon has attended:
Excel Advanced course
Formuals Lookup based on formatting of cells
Is there a LOOKUP function or any formula whereby you can retrieve data based on the formatting of a cell e.g. only retrieve relevant cells that are coloured red in the selected range?
RE: Formuals Lookup based on formatting of cells
Hello Sharon
Thank you for your question.
As far as I am aware, it is only possible to do this in Excel without using VBA coding, by using filter by colour. So it depends on whether your data is arranged in a series of columns with headings (i.e. a list or database) as to whether this will be useful for you.
You can find more information here:
http://office.microsoft.com/en-us/excel/HP100739411033.aspx #Filter%20by%20cell%20color,%20font%20color,%20or%20icon%20set
Kind regards
Amanda
RE: Formuals Lookup based on formatting of cells
Dear Amanda,
thanks for your response, i don't think i explained my question properly. What i am trying to do is create a VLOOKUP based on cell colour e.g. bring back a sum of all red cells on row 10?
Many thanks
Sharon
RE: Formuals Lookup based on formatting of cells
Hi Sharon
This would definitely require VBA coding, as there isn't anything in Excel that can select/identify cells based on cell colour with the exception of the filter by colour.
If the cells are red for a specific reason, e.g. this denotes that a value is over/under a specific amount, or contains a specific word, i.e. if the criteria was based on what was in the cell rather than it's colour I might be able to suggest something to help you - is this the case?
Amanda
