Conditional formatting based on a list
Solved
SergeV
-
SergeV -
SergeV -
Hello,
I'm looking for a way to highlight a cell if the cell value is contained in a list.
Example:
From A1 to I1 I have (in a row) the numbers from 1 to 9 (A1=1, B1=2, C1=3, etc...)
From K1 to M1 I have my list of numbers (for example: K1=3, L1=5, M1=8).
By using a formula in the conditional formatting for the range A1 to I1, I would like to highlight 3 (C1), 5 (E1), and 8 (H1) (because they are in my list from the range K1 to M1).
Is this possible?
Thank you in advance for your responses.
Configuration: Windows 7 / Firefox 49.0
I'm looking for a way to highlight a cell if the cell value is contained in a list.
Example:
From A1 to I1 I have (in a row) the numbers from 1 to 9 (A1=1, B1=2, C1=3, etc...)
From K1 to M1 I have my list of numbers (for example: K1=3, L1=5, M1=8).
By using a formula in the conditional formatting for the range A1 to I1, I would like to highlight 3 (C1), 5 (E1), and 8 (H1) (because they are in my list from the range K1 to M1).
Is this possible?
Thank you in advance for your responses.
Configuration: Windows 7 / Firefox 49.0