Hi there!

I have a question about conditioning formatting that I hope you're able to help.

I wanted to set a range of cells to automatically create a hyperlink based on the data typed into it. for example, if I type '20300' into cell A1, I would like the display text to change from '20300' to US_00020300 and have it hyperlink to 'http://scr.blahblahblah.com/CHRDetails.pl?CHRID=US_00020300'.

Is this doable? Please help.
Thanks in advance!