Hello
I attach a xlsx file for some help.
Go to cell E2. I want that the color of the cell becomes white if the value n.1 is between Item 1 minimum and maximum (see values in blue table).
Ok I can use conditional formatting and it's simple for a single cell.
Now I want to apply the formatting to the other cells (related to the other items) of the green table. How can I do (without repeating the passages 100 times ?) ?
thanks a lot
Excel.xlsx
Bookmarks