ListBox - highlight last row if WK** < current WK

[colaps]

Hello,

Is it possible to keep or create highlighted cells ( last row cells ) if condition met?
Mainly I need to highlight the bottom cells corresponding to each WK number that is smaller than the current WK number.

I have looked if i can read the source of my listbox and keep the formatting that I already have there , but seems it`s not possible, soo now I'm stuck .

this is my listbox :

this is the excel file that is used as source for my listbox:

Rule of the highlight is : if WK * < current WK , cells highlighted.
This highlight of the prior cells, from last weeks needs to be kept. ( exactly as in the excel file )

I need to have same highlighting as in my excel , on my listbox.
Is this possible ?

p.s. this is the method i address to the source for my listbox:
ListBox1.RowSource = "A1:K50"

Thanks in advance.

 

[Fluff]

I need to have same highlighting as in my excel , on my listbox.
Is this possible ?

Unfortunately it's not possible