Advice wanted

RickN
RickN
in Modeling

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

Answers

  • kpasko
    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
    Venki9902

    Hi @RickN,

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

    image.png
    image.png
    image.png
    image.png

    Regards,
    Venkatesh

Categories