Minx_Minxy
New Member
- Joined
- Jul 13, 2015
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Hi,
<tbody>
</tbody>
I need to highlight duplicates in column A, but only if column B is equal to 10.
<tbody> </tbody> In the example above, what I want it to do is, as soon as I input the value on column A the cell automatically changes colour highlighting only cells A1 and A10. I have tried using sumproduct and countifs on conditional formatting, but it does not highlight the values. Thank you in advance. |
<tbody>
</tbody>