JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
thought this would be best explained with an image. Is it possible to use the "key" as conditional formatting?
So for example any cell in column A with "Apple" will match its formatting in cell D4
thought this would be best explained with an image. Is it possible to use the "key" as conditional formatting?

So for example any cell in column A with "Apple" will match its formatting in cell D4