98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formuals Lookup based on formatting of cells | Excel forum
Formuals Lookup based on formatting of cells | Excel forum
Resolved · Urgent Priority · Version 2007
Fri 5 Jun 2009, 09:57Delegate Sharon said...
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?
Mon 8 Jun 2009, 11:28Trainer Amanda said...
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
Mon 8 Jun 2009, 11:34Delegate Sharon said...
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
Mon 8 Jun 2009, 11:40Trainer Amanda said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Enter formulae into multiple cellsIf a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell. |
