Auto Remark Text and color columns based on condition

Are GCS codes unique to one Name?

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

For the first question.

I4 = B4&C4&D4

J4= countif($I$4:$I4,$I4) and drag down.

Then filter on column J for the value > 1 to get the duplicated ones.

Since you did not add an excel file I can not show it to you.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new, I will provide the link for you this time: https://www.mrexcel.com/board/thread...ition.1139082/.)

question 2

sheet references.

Add new column A.

A3 =D3&B3&C3 and drag down.


Sheet MISC claim tracker

K4 =IF($E4>VLOOKUP($I4,References!$A$3:$E$7,5,0),"orange","") and drag down.

Here is a proposal that is very similar to oeldere's:
Populate column A using: =C4&D4&E4&G4
Conditional formatting rule for red: =COUNTIFS($A$4:$A4,$A4)>1
For orange: =$F4>AGGREGATE(15,6,References!$D$3:$D$7/((References!$C$3:$C$7=$C4)*(References!$B$3:$B$7=$E4)),1)
Formula to populate column I:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.