I have a column A that contains a 1-4 word phrases in each cell.
I also have 4 cells that contain 1 word values:
B1 C1 D1 and E1
I need to setup conditional formatting is such a way, that:
1) If text in a cell from column A contains a word that matches value from ONE of the cells mentioned above, highlight that cell (from column A) in red.
2) If text in a cell from column A contains words that matches value from TWO of the cells mentioned above, highlight that cell (from column A) in blue.
3) If text in a cell from column A contains words that matches value from THREE of the cells mentioned above, highlight that cell (from column A) in yellow.
4) If text in a cell from column A contains words that matches value from all FOUR of the cells mentioned above, highlight that cell (from column A) in green.
View an attached image for illustration:
When I change a value in any of B1 C1 D1 or E1 cells, I want it to be reflected in the column A, if not immediately then by the means of running some sort of macro.
I suspect it should be either conditional formatting by formula or by running some sort of macro...
P.S: I use Excel 2010