New to forum - I would like to shade a range of cells based on a value entered in another cell. For example if I enter "5", I would like to shade the next 5 cells in a row. I have tried conditional formatting, but have not been successful. Thank you in advance for your help!