I would like to write a conditional formatting VBA that allows any cell that contains certain words by formatted as well as the cell immediately above it.
So for example
A2: 4
A3: Apples
A4: 5
A5: Oranges
A6: 8
A7: Apples
In this case cells A3 and A7 contain the would ‘Apple” so cells A2, A3, A6 and A7 would all be formatted the same. Cell A5 contains the word Orange so cells A4 and A5 would be formatted differently, etc etc. My eventual list could contain 30 words. Some of the words will require the same formatting but the majority won't. How does one access the correcting coding for the colour spectrum?
So for example
A2: 4
A3: Apples
A4: 5
A5: Oranges
A6: 8
A7: Apples
In this case cells A3 and A7 contain the would ‘Apple” so cells A2, A3, A6 and A7 would all be formatted the same. Cell A5 contains the word Orange so cells A4 and A5 would be formatted differently, etc etc. My eventual list could contain 30 words. Some of the words will require the same formatting but the majority won't. How does one access the correcting coding for the colour spectrum?