Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup help
I am inexperienced with lookup functions, but was told that a lookup equation could be generated to compare the contents of "Column A" with contents of "Column B', and if there are matches, to change the cell format (color, font, etc) to show same values. Can anyone clue me in
Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup help
select column A
Assume cell A1 is the activeCell in the selection go to Format=conditional formatting in the menu Change Cell value is to Formula is put in a formula like =Match($A1,$B:$B,0) Then click the format button and go to the pattern tab. Select a color OK your way out. -- Regards, Tom Ogilvy "mreinders" wrote in message ... I am inexperienced with lookup functions, but was told that a lookup equation could be generated to compare the contents of "Column A" with contents of "Column B', and if there are matches, to change the cell format (color, font, etc) to show same values. Can anyone clue me in? Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup help
mreinders wrote:
I am inexperienced with lookup functions, but was told that a lookup equation could be generated to compare the contents of "Column A" with contents of "Column B', and if there are matches, to change the cell format (color, font, etc) to show same values. Can anyone clue me in? If I understand well, you want something like: Column A Column B Pears Apples Apples Peaches Oranges Oranges <---- Same Format Melon Grapes To do this, you need to use conditional formatting, It is in Format/Conditional Formatting... Then just use the dialog presented to do the proper formatting, remember to format both first cells in column A and B, this is: format first cell to be compared in Column A and Format first cell to be compared in Column B. When creating the Conditional formatting, remove all absolute references (Ex: $A$1 - A1 ) so you can then copy the format dowm. Regards, -- Beto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |