Hot to format a row

[#1]

Hello All,

Please check the attached file and give me an idea how to do it!

I want to format every first line of the vendors based on the date .In the excel file I changed the color to red.

Thanks,

[MayilVahanan]

Hi

Try with FirstSortedValue() function

Hope it helps

[#3]

Could you please give me an example ?

Thanks,

Nima

[disqr_rm · Accepted solution]

Enlosed!

[#5]

Nice job Rakesh,

Thanks a lot.....

[disqr_rm]

Sure, Nima. Thanks!

The key is to disable the interactive sort in this case as if user sorts the table by any other column than Vendor, results will nto be same.