Conditional formatting and transpose
Closed
lizzy
-
Jul 16, 2009 at 10:16 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 20, 2009 at 11:29 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 20, 2009 at 11:29 PM
Related:
- Conditional formatting and transpose
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Notepad++ transpose row to column ✓ - Excel Forum
- Code for formatting android phone - Guide
5 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 17, 2009 at 12:33 AM
Jul 17, 2009 at 12:33 AM
Hello lizzy
Do a vlookup to get either of the figures to make both of them rowwise / column wise
then do a comparison in the near by column using if
The do a conditional formatting based on this cells value for the entire row /column
Do a vlookup to get either of the figures to make both of them rowwise / column wise
then do a comparison in the near by column using if
The do a conditional formatting based on this cells value for the entire row /column
Hi Excelguru,
Thanks for your reply! I'm so glad that there seems to be a solution for this :)
Would you be so kind as to go more into detail with your suggestion? And the thing is, the cells that contain the values are linked to another spreadsheet. So I don't really know how to include the filepath into the formular with the vlookup. (I think I'm doing something wrong here, but Excel Help is not really bringing me any further...)
What do you mean with the near by column? Unfortunately I'm no good with vlookup - that was the one I used to copy in exams... ;)
I would be soo grateful if you could explain it to me in a simple way :)
Have a great day!
Thanks for your reply! I'm so glad that there seems to be a solution for this :)
Would you be so kind as to go more into detail with your suggestion? And the thing is, the cells that contain the values are linked to another spreadsheet. So I don't really know how to include the filepath into the formular with the vlookup. (I think I'm doing something wrong here, but Excel Help is not really bringing me any further...)
What do you mean with the near by column? Unfortunately I'm no good with vlookup - that was the one I used to copy in exams... ;)
I would be soo grateful if you could explain it to me in a simple way :)
Have a great day!
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 17, 2009 at 03:37 AM
Jul 17, 2009 at 03:37 AM
Hello Lizzy
The syntax of vlookup is
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
to get entries to a row
=vlookup(a1, sheet2!$a$1:$b$5,2,false) to get your data where sheet2!$a$1:$b$5 contains your data in columns
Open both the files then select the range in the formula.
The syntax of vlookup is
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
to get entries to a row
=vlookup(a1, sheet2!$a$1:$b$5,2,false) to get your data where sheet2!$a$1:$b$5 contains your data in columns
Open both the files then select the range in the formula.
Hey :)
Thanks again!
After now having tried all kinds of vlookup-things and conditional formatting, I still have not been able to achieve the desired result. And I really do not want to do it manually... Please help me :)
I guess, I did not express myself very well enough... The two data tables are both in the same spreadsheet and the data is not in any order at all - so there is no chance of sorting it in an ascending or descending way. I guess this is what makes the vlookup difficult or impossible, as far as I have now figured that out.
And its still the problem of comparing vertical data to horizontal one - is there maybe a possibility to use the transpose function in combination with the conditional formatting?
If it cannot be worked out with Excel functions, maybe someone can help me finding a solution with VBA... I will be grateful for anything...
Thanks a lot!
Thanks again!
After now having tried all kinds of vlookup-things and conditional formatting, I still have not been able to achieve the desired result. And I really do not want to do it manually... Please help me :)
I guess, I did not express myself very well enough... The two data tables are both in the same spreadsheet and the data is not in any order at all - so there is no chance of sorting it in an ascending or descending way. I guess this is what makes the vlookup difficult or impossible, as far as I have now figured that out.
And its still the problem of comparing vertical data to horizontal one - is there maybe a possibility to use the transpose function in combination with the conditional formatting?
If it cannot be worked out with Excel functions, maybe someone can help me finding a solution with VBA... I will be grateful for anything...
Thanks a lot!
Didn't find the answer you are looking for?
Ask a question
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 20, 2009 at 11:29 PM
Jul 20, 2009 at 11:29 PM
Just to inform you that vlookup does not require a sorted list