Hi @oumayma_lajili1,
Try this below Link for set colour Range without using application Scope:
Hope this helps,If it works, mark it as solution.
Thanks, Neelima.