Hi,
Is there any way that if for you enter a number in cell A1 for example that the corresponding number of cells will highlight in column B?
eg - Cell A1 - 4 is entered. Any way then that this then highlights cells B1-4 in any way (by colour, border, number, letter or anything)?
Cell A1 - 2 is entered so B1 and B2 are highlighted in some way.
Been racking my brain and searching but not found anything. Last hope before I decide it can't be done is the fine folk on here.
Thank you.
Is there any way that if for you enter a number in cell A1 for example that the corresponding number of cells will highlight in column B?
eg - Cell A1 - 4 is entered. Any way then that this then highlights cells B1-4 in any way (by colour, border, number, letter or anything)?
Cell A1 - 2 is entered so B1 and B2 are highlighted in some way.
Been racking my brain and searching but not found anything. Last hope before I decide it can't be done is the fine folk on here.
Thank you.