Minx_Minxy
New Member
- Joined
- Jul 13, 2015
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
Hi,
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"] I need to highlight duplicates in column A, but only if column B is equal to 10.
[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
</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.
[/TD]
[/TR]
</tbody>[/TABLE]
68923 | 10 |
68923 | 20 |
68923 | 30 |
68924 | 10 |
68924 | 20 |
68925 | 10 |
68926 | 10 |
68927 | 10 |
68928 | 10 |
68923 |
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"] I need to highlight duplicates in column A, but only if column B is equal to 10.
[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
</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.
[/TD]
[/TR]
</tbody>[/TABLE]