NealGowdy11
New Member
- Joined
- Sep 20, 2016
- Messages
- 14
A | B | C | D | |
1 | Project Name | Country | Sub Region | Project Manager |
2 | Alpha | UK | NE | Homer Simpson |
3 | Bravo | Russia | EE | Snoop Dogg |
4 | Charlie | Italy | SE | Brad Pitt |
5 | Delta | France | CE | Viktor Reznov |
<tbody>
</tbody>
I need help...
I would like column D to say:
Homer Simpson whenever column C says NE
Snoop Dogg whenever column C says EE
Brad Pitt whenever column C says SE
Viktor Reznov whenever column C says CE
The conditional formatting would apply to A2:C500.