Forum Discussion
Excel Formula Help
Copy/Paste of what I sent you in a Private Message (w/o the attachement - see in PM)
OK, so if I understand you well, with the pictures you shared, you were saying that the Cond. Format. rule didn't do what you expect. Could you double-check the attached version? I checked a few and this looks good to me....
TBH I have no idea why this didn't work before and why it does now as the only changes I made are:
- Formatted your data in 'Yard Equipement Dump' as Table named TableYardEquip
- Created Named Range YardEquipTrailers (=TableYardEquip[Trailer SCAC])
for clarity and to be more efficient than provisioning as you did with:
=IF(COUNTIF('Yard Equipment dump'!$A$2:$A$260,$D2)...- Updated the Cond. Format rule as follow:
=IF(COUNTIF(YardEquipTrailers,$D2), COUNTIF($D$2:$D2,$D2) <= COUNTIF(YardEquipTrailers,$D2))
You will have to update it accordingly in VBA...
I'm not really good at VBA but there are some "strange" (to me) things in your code. Probably something you should consider look at... I would also recommend:
- Resize Table5 to its actual number of rows
- Update the Cond. Format. rule Applies to: accordingly
- In VBA work with Table5 (perso. I would give it a name) instead of sheet 'Finished FA'
(If you need help with VBA there are good guys on this Community)