noslenwerd
Board Regular
- Joined
- Nov 12, 2019
- Messages
- 85
- Office Version
- 365
Below is an example of what I would like to happen in the top row (B1:D1), when a value is found in the range A2:A5.
So basically in the conditional formatting of B1, I want it the formula to essentially say:
If any value from (A2:A5) is found in (B2:B5), change B1 to Green.
Hope this makes sense
So basically in the conditional formatting of B1, I want it the formula to essentially say:
If any value from (A2:A5) is found in (B2:B5), change B1 to Green.
Hope this makes sense