View original (French)

Excel: Highlight text if present in another sheet

Axelle -  
Raymond PENTIER Posted messages 58208 Registration date   Status Contributor Last intervention   -

Hello,

As part of tracking my diet, I started an Excel file that looks like this:

_A first sheet titled MENU which includes the title of my recipe and the details of the ingredients divided into 3 categories (starch, protein, vegetable).

_A second one titled ALIMENTS that lists all the foods according to the categories of the first sheet but in the form of 1 cell = 1 food item.

Question: is there a way to automatically bold the text (or color the cell) in my ALIMENTS sheet if its name has been entered in my MENU sheet? For example, Potatoes, Carrots, and Green Beans as shown below.

Thank you in advance!

1 answer

Answer 1 / 1
Raymond PENTIER Posted messages 58208 Registration date   Status Contributor Last intervention   17 478
 

Hello.

In addition to your screenshots, can you send your Excel file?

This will save us from having to create it ourselves again...

Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
0