Hi folks
Having another crack at this one.. (see attachement)
So i want a formula that when i key in a number in Cell A1, that it completes B2 and C2
In B2, i want it to auto select from a number range, and give me text
In C2, i want text colour and the text to be that colour
so for example.. if i key in 15(A1), it looks to the table of ranges F1-F6 (this one being B11-20) and output in B2, and in C2 it will look to the names and colours in G2-G6 and output RED in this example.
Thanks folks!
Nick
Bookmarks