danbates77
New Member
- Joined
- Jan 10, 2017
- Messages
- 36
- Office Version
- 2016
Hi,
I would like a formula that I can use in conditional format so if I have a duplicate in column A it then checks column E to see if that's the same or not.
I've created an example below.
As you can see col A has two 1's. So when this happens I would like the formula to then check col E and because the two numbers are different I would like it to fill in red
Any help would be appreciated.
Thanks
Dan
I would like a formula that I can use in conditional format so if I have a duplicate in column A it then checks column E to see if that's the same or not.
I've created an example below.
As you can see col A has two 1's. So when this happens I would like the formula to then check col E and because the two numbers are different I would like it to fill in red
1 | Coffee | XI | 144 | 5 |
2 | Coffee | XX | 168 | 3 |
3 | Milk | AA | 234 | 16 |
4 | Coffee | JP | 192 | 19 |
1 | Coffee | XI | 126 | 1 |
Any help would be appreciated.
Thanks
Dan