This is a weird one that I would appreciate advice on
I have a range of filtered results in column R and I have a search box on a worksheet to select employee name then results referenced to a series of text boxes
For example some have contract end date and some dont.
I have mapped out a series of Text boxes and want to pick up the value of say cell R47
That's fine if a value but if cell blank the text box is still showing 0 when referencing cell and looks really untidy
I have tried ISBLANK and conditional formatting font white but to no avail.
Seems simple but I cant figure out a way around this and just want the text box blank in this scenario.
regards
I have a range of filtered results in column R and I have a search box on a worksheet to select employee name then results referenced to a series of text boxes
For example some have contract end date and some dont.
I have mapped out a series of Text boxes and want to pick up the value of say cell R47
That's fine if a value but if cell blank the text box is still showing 0 when referencing cell and looks really untidy
I have tried ISBLANK and conditional formatting font white but to no avail.
Seems simple but I cant figure out a way around this and just want the text box blank in this scenario.
regards