Conditional formatting based of value in another cell

[Golaidron]

Hi all.

Do you guys have a simple excel formula that i can use in Conditional formatting.

In Cell A1 i have value from 1-5.
If it's 1 I want B1 to get colored.
If it's 2 I want B1 and C1 to get colored
If it's 3 I want B1, C1 and D1 to get colored
and so on.

Or do i need to create 5 different formula's for this?

Hope to hear from you soon.

 

[Fluff]

Glad we could help & thanks for the feedback.