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.
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.