Contitional Formatting Cells based on Value of a cell

[Ch999]

Hi Everyone,

Love this site, new user and already glad to be here!

I have an issue I just cannot figure out, I think I need a new perspective.

We have a worksheet which displays data from a report run each morning.
This report shows us shipments coming in for the week, however it has a flaw.

Each shipment has 2 fields that need to be looked at, F and G.

F is CNTR and G is HBL.

If the HBL field is duplicated (above or below in column G) then I need that entire rows data blanked out (row not deleted.)

I also need to remove all duplicates of the CNTR field (can wipe out the entire line as there should never be a duplicate CNTR)

Sheet goes from A4-AU4 and the length of the report varies so I would need some kind of loop to look for an empty cell in A column (once blank stop.)

Anyone know how this can be done? I am still new to VBA but am learning.

Thanks ANyone who can offer some help

 

[etaf]

=COUNTIF(G:G,$G1)>1
format
and apply across the whole range - that will highlight the row - so you could grey out - but will remove all the duplicates - does not leave just one entry clear

same for F
=COUNTIF(F:F,$F1)>1

you will need VBA to remove lines - not my expertise

and will apply no matter what the size - i guess you meed VBA - so you can apply to any new workbook