Advice wanted

RickN

Hi,

I have expense list (5 list items) and one line item (Key fig list formatted).So for each expense list I need to assign one key fig.

Suppose for travel expense list item If I have assigned Key fig1 and for the next expense also i have assigned key fig 1 then it should show in blue color indicating that each expense type should have one key fig 

Thanks

kpasko

Hi,

You might want to try using ISFIRSTOCCURRENCE to indicate specific item appearing for the first time.

Then, any items for which the boolean = False will be the ones for which you need to set up conditional formatting = blue.

Kind regards,

Kamil

Venki9902

Hi @RickN,

I have followed the below steps achieve this.
Hope this helps :)

Regards,
Venkatesh