Duplicate values within same row

Thank you. I think I've uploaded it correclty.

I think you would need separate CF formulae for each of the possibilities. For example. 0.5, 1.0, 1.5, 2.0, D, F, etc. I suspect that may not be scalable.

Originally Posted by Littlesimon

Thank you. I think I've uploaded it correclty.

Ok, I think I've solved for this request. I've create a sub that will:

**NOTE: You need to remove conditional formatting from the sheet for the macro to functionally work (otherwise the conditional format will take precedence over what the macro is trying to accomplish.)
1.) Target a passed in worksheet reference
2.) Loop through each cell in UsedRange Column A
3.) Nested double loop through each UsedRange in the row of the iteration in #2 (we're looping through the rows, then nested double-looping through all the used cells in each row)
4.) Check for equality, and that the cell references are not targeting the same cell
5.) If both cells are equal and un-highlighted, highlight them based on a priority list in the Color List sheet (configurable by you as you'd like)
6.) If one of the cells is already highlighted, set the other cell to that highlight.
7.) I hooked the sub up to a on-change event in the VBA module for the Test Sheet to give you an example, if you type a new value or paste in new data, it should re-run the macro on the sheet. You can do this for any/all sheets, or just trigger the macro through a manual process.

You can manually fire the macro like this in a VBA module:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I removed the upload.

For an automatic kick off

You need to open the VBA code editor and add that code block you shared into each sheet object that you want the code to auto fire in.

Please Login or Register  to view this content.

For a manual kick off:

In the VBA code editor, create a new code module (google how to do this if needed, it's very easy).

In the code module create a new sub, something like:

Please Login or Register  to view this content.

Change the "MySheet" to the name of the sheet.


For your additional requirements, could I have you please be very clear on what you're asking for? If you can illustrate it with an example workbook even better.