I like to create a formula for conditional formatting base on value from another cell
A1=Input numbers between 1-10
A2:A11 = shaded/filled based on value from cell A1
Example
If A1=3
A2:A4 is shaded/filled
If A1=5
A2:A6 is shaded/filled
If A1=8
A2:A10 is shaded/fill
Any tips/solution would be greatly appreciated.
Cheers!
A1=Input numbers between 1-10
A2:A11 = shaded/filled based on value from cell A1
Example
If A1=3
A2:A4 is shaded/filled
If A1=5
A2:A6 is shaded/filled
If A1=8
A2:A10 is shaded/fill
Any tips/solution would be greatly appreciated.
Cheers!