Comment mettre en couleur les multiples communs de 3 nombres qui forment un tableau de plusieurs lignes dans excel? Merci
Comment mettre en couleur les multiples communs de 3 nombres qui forment un tableau de plusieurs lignes dans excel? Merci
1 comment

A.C. WILSON commented
(English translation: "How can one colo(u)r the cells of the common multiples of three numbers, which comprise a table of multiple rows in Excel?")
Your example has a column for the original integers, plus 3 more columns  one column for each set of multiples.
I can envisage a solution. (For simplicty, let us assume that all of the numbers are positive integers (also called "whole numbers"), as in your example. Therefore, all of the multiples are also positive integers.)
Do the following:
Create 5th column to the right, but leave it empty.
Create a 6th column to the right. and fill it with every possible integer in sequence, all the way up to the highest possible value of a multiple: "1, 2, 3, 4, 5, 6,..., n"
Create a 7th column adjacent to the 6th column. This 7th column will contain an elaborate formula that makes use of Excel's lookup functions  VLOOKUP() or XLOOKUP(). For each integer in the 6th column, the formula in 7th column will search to see it matches a multiple in each of the 2nd, 3rd, AND 4th columns. If there are matches in all 3 of those columns, inidcating that the integers is common multiple, the formula in the 7th column will return "YES"; if not "NO".
Create an 8th column to the right of the 7th column. The formula in the 8th column will check whether the 7th column's formula contains "NO" or "YES". The 8th column's formula will return 0 if the 7th column indicates "NO". Otherwise, if the 7th column has a "YES", the 8th column's formula will return 1 for the 1st "YES" (from the top), 2 for the 2nd "Yes", 3 for the 3rd "YES", etcetera.
Now, for columns 2, 3, and 4, use Excel's "Conditional Formatting" to set colors. For each multiple in columns 2, 3, and 4, find that same integer in column 6, and use the corresponding value in column 8 to choose the unique color for that multiple.
(Malheureusement, malgre que ma facilite en francais me permis de tres bien diner, elle ne me suffise pas a expliquer comment utilser Excel, dont je n'ai jamais utilise sa version francaise. Excel n'a pas encore existe, quand je bossais en France, il ya 35 ans.)