Advice wanted


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 



  • 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,


  • Hi @RickN,

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